SHARE
TWEET

Untitled

a guest Sep 12th, 2019 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ********************************************************************************
  2.  
  3. SQL ID: avv66b4j5gzx5 Plan Hash: 529439096
  4.  
  5. UPDATE SESSIONS SET SUBSCRIBERID = :B9 , CALLRATE = :B8 , LEGID = :B7 ,
  6.   LIMITID = DECODE( :B5 , 0,TO_NUMBER( NULL ), :B6 ), SESSIONSTATE = DECODE(
  7.   :B5 , 0,:B4 , NULL,:B4 , :B3 ), CALLID = NVL (SESSIONS.CALLID, :B2 )
  8. WHERE
  9.  SESSIONID = :B1
  10.  
  11.  
  12. call     count       cpu    elapsed       disk      query    current        rows
  13. ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  14. Parse       66      0.00       0.00          0          0          0           0
  15. Execute    118      0.04       0.05          1        239        742         118
  16. Fetch        0      0.00       0.00          0          0          0           0
  17. ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  18. total      184      0.05       0.05          1        239        742         118
  19.  
  20. Misses in library cache during parse: 0
  21. Optimizer mode: ALL_ROWS
  22. Parsing user id: 118     (recursive depth: 1)
  23. Number of plan statistics captured: 118
  24.  
  25. Rows (1st) Rows (avg) Rows (max)  Row Source Operation
  26. ---------- ---------- ----------  ---------------------------------------------------
  27.          0          0          0  UPDATE  SESSIONS (cr=2 pr=0 pw=0 time=154 us)
  28.          1          1          1   INDEX UNIQUE SCAN SESSIONS_PRIMARY (cr=2 pr=0 pw=0 time=7 us cost=1 size=116 card=1)(object id 62650)
  29.  
  30.  
  31. Elapsed times include waiting on following events:
  32.   Event waited on                             Times   Max. Wait  Total Waited
  33.   ----------------------------------------   Waited  ----------  ------------
  34.   db file sequential read                         1        0.00          0.00
  35. ********************************************************************************
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top