Re: Transaction table- Keep Pool

From: Mike Killough <mwkillough_at_hotmail.com>
Date: Thu, 05 Aug 2004 10:09:18 -0500
Message-ID: <BAY17-F44n82ptmYLnS00114955@hotmail.com>

Yes, a small number of rows returned, but a large number of logical IO's. Also, a third of these come from disk. Look into the merge join cartesian seen in the explain plan.

Mike

>It is taking 30 sec for such a small volume of records.
>
>call count cpu elapsed disk query current
>rows
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>Parse 1 0.03 0.05 0 0 0
> 0
>Execute 1 0.00 0.00 0 0 0
> 0
>Fetch 3 10.71 33.30 6345 19185 0
> 20
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>total 5 10.74 33.35 6345 19185 0
> 20
>
>Misses in library cache during parse: 1
>Optimizer goal: CHOOSE
>Parsing user id: 180
>
>Rows Row Source Operation
>------- ---------------------------------------------------
> 20 COUNT STOPKEY
> 20 VIEW
> 20 SORT ORDER BY STOPKEY
> 347 MERGE JOIN CARTESIAN
> 348 NESTED LOOPS
> 4884 TABLE ACCESS BY INDEX ROWID PROFILEDUSER
> 4885 INDEX RANGE SCAN (object id 1010125)
> 5230 TABLE ACCESS BY INDEX ROWID EXTENDEDATTRIBUTES
> 9766 INDEX UNIQUE SCAN (object id 951554)
> 347 SORT JOIN
> 1 TABLE ACCESS BY INDEX ROWID COUNTRIES
> 2 INDEX RANGE SCAN (object id 1131957)

Overwhelmed by debt? Find out how to ‘Dig Yourself Out of Debt’ from MSN Money. http://special.msn.com/money/0407debt.armx

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Aug 05 2004 - 10:05:38 CDT