check free extents in a tablespace [message #552847] |
Sun, 29 April 2012 09:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/5e3d913875c539fe5a14a99c089b6e7a?s=64&d=mm&r=g) |
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
|
|
|
|
|