*<TKPROF>*

[kevlar]

UPDATE TB_USED_RCPT_NO SET STATUS='U',LOCAL=:b1,KEY_SEQ=:b2,
EFFC_DATE=:b3
WHERE
TRAN_NO = :b4 AND TRAN_TYPE = :b5 AND KEY_SEQ > 0 AND LOCAL = :b1


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.24 0.32 0 0 0 0
Execute 1 0.48 18.00 2743 2744 18 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.72 18.32 2743 2744 18 1

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer goal: CHOOSE
Parsing user id: 627 (recursive depth: 1)
********************************************************************************

Hi guys,
can u interpret this output.... Thank u guys for the reply, I really appreciate it.

[sambavan]

http://technet.oracle.com/docs/produ...4_str.htm#1311

Sam

[marist89]

Originally posted by kevlar

UPDATE TB_USED_RCPT_NO SET STATUS='U',LOCAL=:b1,KEY_SEQ=:b2, 
EFFC_DATE=:b3 
WHERE 
TRAN_NO = :b4 AND TRAN_TYPE = :b5 AND KEY_SEQ > 0 AND LOCAL = :b1 


call count cpu elapsed disk query current rows 
------- ------ -------- ---------- ---------- ---------- ---------- ---------- 
Parse 1 0.24 0.32 0 0 0 0 
Execute 1 0.48 18.00 2743 2744 18 1 
Fetch 0 0.00 0.00 0 0 0 0 
------- ------ -------- ---------- ---------- ---------- ---------- ---------- 
total 2 0.72 18.32 2743 2744 18 1 

Misses in library cache during parse: 1 
Misses in library cache during execute: 1 
Optimizer goal: CHOOSE 
Parsing user id: 627 (recursive depth: 1) 
******************************************************************************** 

Hi guys, 
can u interpret this output.... Thank u guys for the reply, I really appreciate it.