Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> quick way to get freelist group id (but not from dba_segments)
Hello again,
I wonder if theres a quick method to get the freelist_group_id for a
segment.
but i dont want to:
select freelist_group_id
from dba_segments
where segment_name = xxx
and owner = xxx
and partition_name
and tablespace_name = xxx
because this is pretty slow.i need this information for indexes, tables, table/index partitions so i cannot just select xxx from dba_tables or dba_indexes and so on.
is there a better way?
tia, Frank Zaum, Salzgitter Received on Tue May 21 2002 - 10:41:32 CDT