Thanks a lot

Ron






>From: "Negandhi, Hiten" <[Email Address Removed] 'Ron Krockett' <[Email Address Removed] [Email Address Removed] RE: How to find the Extents availble/used
>Date: Fri, 28 Feb 2003 09:43:22 -0500
>
>Extents are not seen until they are allocated. In dba_free_space, you will
>just see free space in the tablespace.
>Used extents, like I said, will be visible through dba_extents.
>
>
>-----Original Message-----
>From: Ron Krockett [mailto:[Email Address Removed] Friday, February 28, 2003 9:35 AM
>To: Negandhi, Hiten; [Email Address Removed] RE: How to find the Extents availble/used
>
>
>Thanks Hiten..
>
>This is what i see from my database....
>****************************************
>[Email Address Removed] *FROM dba_free_space where tablespace_name =
>'USERS';
>
>TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
>--------------- -------- -------- ------ ------ ------------
>USERS 8 20641 66846720 8160 8
>
>***********************************************************
>
>How to tell how many Extents are used and how many are available ?...
>
>Thanks
>Ron
>
>
>
>"Negandhi, Hiten" <[Email Address Removed] >To: 'Ron Krockett' <[Email Address Removed] "LazyDBA.com Discussion"
> ><[Email Address Removed] >Subject: RE: How to find the Extents availble/used
> >Date: Fri, 28 Feb 2003 09:21:14 -0500
> >
> >for used extents,
> >SELECT *
> >FROM dba_extents
> >where segment_name = '<object_name>'
> >
> >for free space,
> >SELECT *
> >FROM dba_free_space
> >where tablespace_name = '<tablespace_name>'
> >
> >
> >-----Original Message-----
> >From: Ron Krockett [mailto:[Email Address Removed] >Sent: Friday, February 28, 2003 9:10 AM
> >To: LazyDBA.com Discussion
> >Subject: How to find the Extents availble/used
> >
> >
> >
> >Hello all..
> >
> >Oracle 9.2
> >
> >How do i find out how many Extents are used /Availble in a Tablespace and
> >also in a Table ?...
> >
> >I would greatly appreciate it.
> >
> >Thanks
> >Ron
> >
> >
> >
> >
> >_________________________________________________________________
> >MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> >http://join.msn.com/?page=features/virus
> >
> >
> >--------
> >Oracle documentation is here:
> >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> >To unsubscribe: send a blank email to oracledba-[Email Address Removed] >To subscribe: send a blank email to oracledba-[Email Address Removed] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> >Tell yer mates about http://www.farAwayJobs.com
> >By using this list you agree to these
> >terms:http://www.lazydba.com/legal.html
>
>
>_________________________________________________________________
>Add photos to your messages with MSN 8. Get 2 months FREE*.
>http://join.msn.com/?page=features/featuredemail


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus

Oracle LazyDBA home page