RE: Tkprof analysis -- running a procedure is causing it
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "oratips@xxxxxxxxx" <oratips@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 Aug 2008 13:09:47 -0400
Ok.....no SQL statement shown, no questions asked or comments made....
I think the merge join cartesian looks suspicious....not that you asked for any
comments...
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bala
Sent: Thursday, August 14, 2008 12:45 PM
To: oracle-l
Subject: Tkprof analysis -- running a procedure is causing it
Oracle 9.2.0.5<http://9.2.0.5>
Solairs 2.10
Running Oracle Procdure is causing this
##
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 12015 12.55 12.51 1 2940 0 0
Fetch 13553 45978.60 53103.20 32310734 3968132258 0 1538
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 25569 45991.15 53115.72 32310735 3968135198 0 1538
--
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID PS_PERSONAL_DATA
0 INDEX UNIQUE SCAN PS_PERSONAL_DATA (object id 291707)
1538 TABLE ACCESS BY INDEX ROWID PS_BI_LINE
3187778022 NESTED LOOPS
2619243520 MERGE JOIN CARTESIAN
11746 TABLE ACCESS BY INDEX ROWID PS_CA_DETAIL_PROJ
11746 INDEX RANGE SCAN PSACA_DETAIL_PROJ (object id 877553)
2619243520 BUFFER SORT
2617981990 INDEX RANGE SCAN PS1BI_HDR (object id 206737)
568522487 INDEX RANGE SCAN PSBBI_LINE (object id 507065)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 32310734 9.63 9381.11
latch free 2781 0.02 0.61
####
Bala Rao
Other related posts:
