TKPROF question
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: "Oracle List (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 10:54:54 -0500
<some big bad MERGE statement here>
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 5 0 0
Execute 6 213.15 949.43 393775 10256309 20885 10094
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 213.16 949.45 393775 10256314 20885 10094
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 47 (recursive depth: 1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
global cache cr request 191074 3288.24 3352.21
db file sequential read 392778 0.16 717.89
global cache s to x 88 0.00 0.02
direct path write 11 0.00 0.01
direct path read 128 0.00 0.03
db file scattered read 45 0.07 0.38
global cache open s 3 0.00 0.00
global cache open x 45 0.00 0.01
********************************************************************************
Okay ... so this is 9204 db, and I am trying to correctly interpret the
MAX.WAIT column value for 'global cache cr request' ... I assume that max wait
means in all waits this was the max value for given wait event. right? If so,
Did I really have wait of 3288.24 (seconds, centi seconds, milliseconds???)
If so, I can't see that in the trace file, I checked all the 'ela=' values for
wait event g_c_cr_r .... where the heck this value 3288.24 came from? And how
do I find it? Truse me, the trace file is > 5G.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
select standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an art !
Other related posts:
