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



Oracle LazyDBA home page