how time is useful in tkprof 12.1.0.2
Hi All experts,
We would like to understand the tim parameter in tkprof rowsource stats. Please give some idea.Is it time taken by each operation.
Below sample tkprof
call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 3.55 99.71 16170 457312 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 3.55 99.71 16170 457312 0 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=228656 pr=16170 pw=0 time=98732632 us) 40100 40100 40100 CONCATENATION (cr=228656 pr=16170 pw=0 time=93280174 us) 0 0 0 NESTED LOOPS (cr=11553 pr=0 pw=0 time=357148 us cost=13009 size=113 card=1) 0 0 0 NESTED LOOPS (cr=11553 pr=0 pw=0 time=357146 us cost=13009 size=113 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED WF_NOTIFICATIONS (cr=11533 pr=0 pw=0 time=356996 us cost=12980 size=17 card=1) 1 1 1 INDEX SKIP SCAN WF_NOTIFICATIONS_N6 (cr=11532 pr=0 pw=0 time=356988 us cost=12979 size=0 card=1)(object id 194234) 0 0 0 PARTITION RANGE ALL PARTITION: 1 14 (cr=20 pr=0 pw=0 time=148
0