Hello,

The following sql statement is running for a long time. Where as all other statements are running as normal.

Select
owner,
segment_name,
segment_type
from
dba_extents
where
file_id = &P1
and
&P2 between block_id and block_id + blocks -1;

Is this a normal behaviour whenever we try to pull some information on blocks?

Thanks,
Nikee