Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> quick way to get freelist group id (but not from dba_segments)

quick way to get freelist group id (but not from dba_segments)

From: Frank Zaum <frankzaum_at_yahoo.de>
Date: 21 May 2002 08:41:32 -0700
Message-ID: <4c1e5bbe.0205210741.19e83a72@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US