| 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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
