|
|
| Re: How to find db size, blah blah. [message #73182 is a reply to message #72509] |
Thu, 26 February 2004 02:49  |
Padmanathan
Messages: 2
Registered: February 2004
|
Junior Member |
|
|
Hi Try this,
select sum(total_available) Total,
sum(total_in_use) In_Use,
sum(total_free) Free
from
(
select v1.tablespace_name,
v1.total_available,
v2.total_in_use,
v3.total_free
from
(select tablespace_name,
sum(blocks) total_available
from sys.dba_data_files
group by tablespace_name ) v1,
(select tablespace_name,
sum(blocks) total_in_use
from sys.dba_extents
group by tablespace_name) v2,
(select tablespace_name,
sum(blocks) total_free
from sys.dba_free_space
group by tablespace_name ) v3
where
v1.tablespace_name = v2.tablespace_name
and
v1.tablespace_name = v3.tablespace_name
);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
