********************************************************************************

SQL ID: avv66b4j5gzx5 Plan Hash: 529439096

UPDATE SESSIONS SET SUBSCRIBERID = :B9 , CALLRATE = :B8 , LEGID = :B7 ,
  LIMITID = DECODE( :B5 , 0,TO_NUMBER( NULL ), :B6 ), SESSIONSTATE = DECODE(
  :B5 , 0,:B4 , NULL,:B4 , :B3 ), CALLID = NVL (SESSIONS.CALLID, :B2 )
WHERE
 SESSIONID = :B1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       66      0.00       0.00          0          0          0           0
Execute    118      0.04       0.05          1        239        742         118
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      184      0.05       0.05          1        239        742         118

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 118     (recursive depth: 1)
Number of plan statistics captured: 118

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         0          0          0  UPDATE  SESSIONS (cr=2 pr=0 pw=0 time=154 us)
         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)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file sequential read                         1        0.00          0.00
********************************************************************************