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] 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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
Oracle LazyDBA home page