Re: SQL-Tuning Problem

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Wed, 8 May 2002 12:27:15 +0200
Message-ID: <abaui4$sfr$1@news.mch.sbs.de>

Hi Frank,

did we discuss this before?

The plan below seems quite ok. Get all data from dba_segement, the join with your table.

Seems that the data from dba_segments is very large or expensive to gather. How many rows do you get from dba_segments / your query?

==> try the select without the join to determine the run time ==> try c.owner instead of b.owner (which should be the same, but may help the optimizer).

> SELECT STATEMENT
> SORT ORDER BY
> NESTED LOOPS
> VIEW SYS_DBA_SEGS
> snip
> TABLE ACCESS BY INDEX ROWID SPACE_VALUES
> INDEX UNIQUE SCAN SPACE_VALUES_PK
>
>
> TIA, Frank Zaum.
Received on Wed May 08 2002 - 05:27:15 CDT