Hi,

I tried without hint and with hint /*+ ROLE */ too but the result is the
same.

Any sugggestion?

Regards,
Battila






"rjs" <oracledba-ezmlmshield-x80509251.[Email address protected]
2007.02.28 12:12

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Re: Identify database object






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
>



---------------------------------------------------------------------
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