Re: Table/index size and number of extents

From: Winnie Liu <poohland_at_hotmail.com>
Date: Wed, 29 Jul 1998 19:40:07 -0700
Message-ID: <6pom62$118@dfw-ixnews10.ix.netcom.com>

If you are talking about how to calculate the number of extents that a table/index have currently, then you can try this method:

select segment_type,segment_name,extent_id from dba_extents
where segment_type ='INDEX' and segment_name =<'NAME OF THE SEGMENT'>;

for table, just change the segment_type from INDEX to TABLE.

The size of the extents really depend on your initial and next parameters for your table. If I remember correctly, there may be a column called 'bytes' in that dba_extents column, check it out!

hope this can help!

Winnie

Harsha Karan wrote in message <35BF7CC4.2DE7_at_priority-health.com>...
>Hi
>
>Can anyone suggest a method to calculate the size and number of extents
>for ( a query )
>
>1. an index
>2. a table
>
>Thanks in advance
>
>Harsha
Received on Wed Jul 29 1998 - 21:40:07 CDT