select a.tablespace_name,
a.bytes_alloc/(1024*1024) “TOTAL ALLOC (MB)”,
a.physical_bytes/(1024*1024) “TOTAL PHYS ALLOC (MB)”,
nvl(b.tot_used,0)/(1024*1024) “USED (MB)”,
(nvl(b.tot_used,0)/a.bytes_alloc)*100 “% USED”
from ( select tablespace_name,
sum(bytes) physical_bytes,
sum(decode(autoextensible,’NO’,bytes,’YES’,maxbytes)) bytes_alloc
from dba_data_files
group by tablespace_name ) a,
( select tablespace_name, sum(bytes) tot_used
from dba_segments
group by tablespace_name ) b
where a.tablespace_name = b.tablespace_name (+)
–and (nvl(b.tot_used,0)/a.bytes_alloc)*100 > 10
and a.tablespace_name not in (select distinct tablespace_name from dba_temp_files)
and a.tablespace_name not like ‘UNDO%’
order by 1
–order by 5
/
a.bytes_alloc/(1024*1024) “TOTAL ALLOC (MB)”,
a.physical_bytes/(1024*1024) “TOTAL PHYS ALLOC (MB)”,
nvl(b.tot_used,0)/(1024*1024) “USED (MB)”,
(nvl(b.tot_used,0)/a.bytes_alloc)*100 “% USED”
from ( select tablespace_name,
sum(bytes) physical_bytes,
sum(decode(autoextensible,’NO’,bytes,’YES’,maxbytes)) bytes_alloc
from dba_data_files
group by tablespace_name ) a,
( select tablespace_name, sum(bytes) tot_used
from dba_segments
group by tablespace_name ) b
where a.tablespace_name = b.tablespace_name (+)
–and (nvl(b.tot_used,0)/a.bytes_alloc)*100 > 10
and a.tablespace_name not in (select distinct tablespace_name from dba_temp_files)
and a.tablespace_name not like ‘UNDO%’
order by 1
–order by 5
/
Thanks for ones marvelous posting! I definitely enjoyed reading
it, you happen to be a great author.I will be sure to bookmark your blog and will
often come back in the future. I want to encourage that you continue your great writing, have a nice morning!
Here is my blog post … nordvpn coupons inspiresensation
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point.
You definitely know what youre talking about, why waste your intelligence on just posting videos to your
blog when you could be giving us something enlightening to
read?
Here is my website: nordvpn coupons inspiresensation (in.mt)
350fairfax nordvpn promotion
Normally I don’t read article on blogs, however I would like to say that this write-up very forced me to try and do it!
Your writing taste has been amazed me. Thanks, very nice post.