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.
I’m not sure exactly why but this web site is loading
extremely slow for me. Is anyone else having this problem or is it a issue on my end?
I’ll check back later on and see if the problem still exists.
Here is my web page – eharmony special coupon code 2025
Why visitors still make use of to read news papers when in this technological world everything is existing on net?
My webpage; vpn
I just like the helpful information you provide in your articles
Hi there to all, for the reason that I am genuinely keen of reading this website’s post to be updated on a regular basis. It carries pleasant stuff.
Great blog right here! Additionally your
web site lots up fast! What host are you the use of?
Can I get your affiliate hyperlink for your host?
I desire my site loaded up as fast as yours lol https://tinyurl.com/2ab5s5qz gamefly
very informative articles or reviews at this time.
very informative articles or reviews at this time.
I appreciate you sharing this blog post. Thanks Again. Cool.
There is definately a great deal to know about
this issue. I like all the points you’ve made. Vpn explained
https://tinyurl.com/24dyn2m6
Thanks for sharing this insightful article.
That is very interesting, You are an excessively skilled blogger.
I’ve joined your feed and look forward to seeking extra of your wonderful post.
Also, I’ve shared your site in my social networks
I’ve been surfing online more than 3 hours nowadays, yet I by no means discovered
any attention-grabbing article like yours. It’s pretty value
enough for me. In my opinion, if all website owners and bloggers made just
right content as you probably did, the web can be much more helpful than ever before.
Hello my loved one! I wish to say that this post is amazing, great written and include approximately all significant infos. I would like to peer extra posts like this . http://www.kayswell.com
Superb post however , I was wanting to know if you could write a litte more on this subject? I’d be very grateful if you could elaborate a little bit further. http://www.kayswell.com
Heya i am for the first time here. I found this board and I to find It truly helpful & it helped me out much. I hope to offer one thing back and help others like you aided me. http://www.kayswell.com
Thanks for one’s marvelous posting! I truly enjoyed reading it, you are a great author.I will ensure that I bookmark your blog and will often come back in the future. http://www.kayswell.com I want to encourage you to definitely continue your great posts, have a nice day!
Somebody essentially assist to make critically posts I would state. That is the first time I frequented your website page and to this point? I amazed with the research you made to make this actual put up amazing. Magnificent task! http://www.kayswell.com
It’s amazing to pay a visit this site and reading the views of all friends regarding this paragraph, while I am also keen of getting know-how. http://www.kayswell.com
I’m not sure if this is a format issue or something to do with internet browser compatibility but I figured I’d post to let you know. The style and design look great though! Hope you get the issue fixed soon. Many thanks http://www.kayswell.com
Nice post. I learn something totally new and challenging on blogs I stumbleupon on a daily basis.It will always be useful to read through content from other authors and use a little something from other websites. http://www.kayswell.com
This is a topic that’s near to my heart… Many thanks! http://www.kayswell.com Where are your contact details though?
These are actually great ideas in about blogging. You have touched some pleasant things here. Any way keep up wrinting.
I really like what you guys tend to be up too. This kind of clever work and reporting! Keep up the amazing works guys I’ve added you guys to my blogroll.
Way cool! Some extremely valid points! I appreciate you penning this write-up and also the rest of the website is really good.
I am really loving the theme/design of your weblog. Do you ever run into any browser compatibility issues? A few of my blog readers have complained about my site not working correctly in Explorer but looks great in Firefox. Do you have any advice to help fix this issue? http://www.kayswell.com
I am sure this article has touched all the internet people, its really really nice post on building up new blog. http://www.kayswell.com
After exploring a few of the blog articles on your site, I seriously like your technique of blogging. I book-marked it to my bookmark webpage list and will be checking back soon. Take a look at my website as well and let me know what you think.
Hi to every body, it’s my first pay a visit of this weblog; this weblog contains remarkable and genuinely excellent material designed for readers.
Nice answers in return of this matter with firm arguments and telling everything concerning that. http://www.kayswell.com
After exploring a few of the blog articles on your site, I seriously like your technique of blogging. I book-marked it to my bookmark webpage list and will be checking back soon. Take a look at my website as well and let me know what you think. http://www.kayswell.com
This paragraph will assist the internet users for building up new web site or even a blog from start to end. http://www.kayswell.com
Aw, this was a very nice post. Taking the time and actual effort to create a great article… but what can I say… I hesitate a whole lot and never seem to get nearly anything done. http://www.kayswell.com
Thank you for the auspicious writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how could we communicate? http://www.kayswell.com