Re: Number Of Extents on tables

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/07/29
Message-ID: <sYAg5.4241$c33.728040@typhoon-news1.southeast.rr.com>#1/1

Iain,

select extents from user_segments where segment_name='your_table_name' will give you the number of extents in the segment

select bytes from user_extents where segment_name='your_table_name' will give you a list of all extents' sizes

Regards,
Paul

"Iain Wiseman" <bibble_at_ibm.net> wrote in message news:39822784_4_at_news1.prserv.net...
> I have set my table storage to be unlimited for sizing of tablespace. How
do
> I find the number of extents used so that I can set the storage correctly.
>
> Iain
> --
> mailto:iwiseman_at_g8labs.co.nz
> --------------------------------------------------------------------------
--
> -----
> For the sword outwears its sheath,
> And the soul wears out the breast,
> And the heart must pause to breathe,
> And Love itself have rest.
>
>
>
>
Received on Sat Jul 29 2000 - 00:00:00 CDT