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

Frank Zaum wrote:

> 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

Get the DDL for dba_segments.

Reverse engineer a query directly to the underlying data dictionary tables.

I doubt you'll save a millisecond but that's your choice.

Daniel Morgan Received on Tue May 21 2002 - 11:59:40 CDT