Home » RDBMS Server » Server Administration » check free extents in a tablespace
check free extents in a tablespace [message #552847] Sun, 29 April 2012 09:41 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
which data dictionary view would you query to see the free extents in a tablespace.

i use dba_free_space;

SQL> select tablespace_name,sum(bytes),sum(blocks) from dba_free_space where
tablespace_name = 'SYSTEM' GROUP BY TABLESPACE_NAME;

TABLESPACE_NAME SUM(BYTES) SUM(BLOCKS)
------------------------------ ---------- -----------
SYSTEM 9830400 1200

m i right or wrong?

regards
pritesh ranjan
Re: check free extents in a tablespace [message #552848 is a reply to message #552847] Sun, 29 April 2012 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>m i right or wrong?
yes, you are right
Re: check free extents in a tablespace [message #552858 is a reply to message #552848] Sun, 29 April 2012 11:51 Go to previous message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Laughing

Previous Topic: which initializaion parameter cant be change
Next Topic: Before ORA-00600 ERROR
Goto Forum:
  


Current Time: Sun Apr 11 05:31:51 CDT 2021