there is an optimizer-hint in the dba_extents-view.
perhaps it's slow under 9.2.0.5
try to recreate your dba_extents-view WITHOUT the optimizer-hint
but remember the original view ... ;-)

let me know if this is a good solution!

Rüdiger J. Schulz
sosys-berlin.de

On Wed, 28 Feb 2007 11:38:34 +0100, "Attila Brunáczky"
<oracledba-ezmlmshield-x24537834.[Email address protected] wrote:

> Hi Everybody,
>
> I used the next SQL to identify database object by p1(FILE_ID) and
> p2(BLOCK_ID).
>
> SELECT owner, segment_name, segment_type
> FROM dba_extents
> WHERE file_id = &p1
> AND &p2 BETWEEN block_id
> AND block_id + blocks - 1;
>
> This SQL statement worked on 8.1.7.4 EE very quickly (some seconds).
> Nowadays I work on 9.2.0.5 EE, but this query is very slow (10-20
> minutes).
>
> Do you have any idea to speed up this query or any other solution to
> identify database object.
>
> Regards,
> Battila
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


Oracle LazyDBA home page