Re: Transaction table- Keep Pool
- From: "Mike Killough" <mwkillough@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 05 Aug 2004 10:09:18 -0500
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
