OraFAQ Forum: Server Administration » check free extents in a tablespace

Home » RDBMS Server » Server Administration » check free extents in a tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

check free extents in a tablespace [message #552847]

Sun, 29 April 2012 09:41

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

Report message to a moderator

Re: check free extents in a tablespace [message #552848 is a reply to message #552847]

Sun, 29 April 2012 09:48

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: check free extents in a tablespace [message #552858 is a reply to message #552848]

Sun, 29 April 2012 11:51

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:27:31 CDT 2024