RE: Tkprof analysis -- running a procedure is causing it

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_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

  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)

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 14 2008 - 12:09:47 CDT