Tkprof analysis -- running a procedure is causing it

From: Bala <oratips_at_gmail.com>
Date: Thu, 14 Aug 2008 12:45:19 -0400
Message-ID: <9ea7ad870808140945j58b1d383rb3572a7f0eb2d770@mail.gmail.com>

Oracle 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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 14 2008 - 11:45:19 CDT