Guest User

Untitled

a guest
Sep 12th, 2019
93
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