ibanes.com 
                        Home | DBA Tips | DBA Scripts | CV | Contact
News

Others

 

Free space by Tablespace

select a.tablespace_name name,
b.tablespace_name dummy,
sum(b.bytes)/count(distinct a.file_id||'.'||a.block_id ) bytes,
(sum(b.bytes)/count(distinct a.file_id||'.'||a.block_id ))/1024/1024 tmb,
sum(b.bytes)/count(distinct a.file_id||'.'||a.block_id ) - sum(a.bytes)/count(distinct b.file_id ) used,
(sum(b.bytes)/count(distinct a.file_id||'.'||a.block_id ) - sum(a.bytes)/count(distinct b.file_id))/1024/1024 umb,
sum(a.bytes)/count(distinct b.file_id) free,
(sum(a.bytes)/count(distinct b.file_id)) / 1024 / 1024 fmb,
100*((sum(b.bytes)/count(distinct a.file_id||'.'||a.block_id )) - (sum(a.bytes)/count(distinct b.file_id ) ))/(sum(b.bytes)/count(distinct a.file_id||'.'||a.block_id)) pct_used
from sys.dba_free_space a, sys.dba_data_files b
where a.tablespace_name = b.tablespace_name
group by a.tablespace_name, b.tablespace_name

Thanks to Srinivas R Chandaka


Oracle Sites

» Oracle Base
» Ask Tom
» DBA Support
» DBA Click
» Dbazine
» SamOraTech
» OraFaq
» SearchDatabase
» Ixora
» DBA on Call
» VS Babu
» OraPub
» Oracle Advice
» Quest Pipelines
» Oracle Professionals
» Jeff Hunter's Site
Links
» The First Resource Repository

Hosted by www.Geocities.ws

1