Spinning package call

Posted by Laurel on Jun 21, 2018; 4:44am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Spinning-package-call-tp6218.html

Hi Erman!
Any idea how to troubleshoot ?
We have  code that just spinning. ADM is saying -> tune this code.
BEGIN package_call.call1(:errbuf,:rc); END;

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1  18237.51   30593.14         13         51          0           1
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2  18237.51   30593.14         13         51          0           1

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 44

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       2        0.00          0.00
  SQL*Net message from client                     2        0.00          0.00
  latch: row cache objects                        1        0.00          0.00
  Disk file operations I/O                        1        0.00          0.00
  direct path read                                4        0.00          0.00
  utl_file I/O                              3857529        0.16         35.14
  log file sync                                   1        0.00          0.00


 alter session set events '10046 trace name context forever, level 8'. Same info
Any idea how to analyze it ?

ThX!
Laurel