set verify off
column file_name format a50 word_wrapped
column smallest format 999,990 heading “Smallest|Size|Poss.”
column currsize format 999,990 heading “Current|Size”
column savings format 999,990 heading “Poss.|Savings”
break on report
compute sum of savings on report
column value new_val blksize
select value from v$parameter where name = ‘db_block_size’;
/
select file_name,
ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest,
ceil( blocks*&&blksize/1024/1024) currsize,
ceil( blocks*&&blksize/1024/1024) –
ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) savings
from dba_data_files a,
( select file_id, max(block_id+blocks-1) hwm
from dba_extents
group by file_id ) b
where a.file_id = b.file_id(+) order by savings desc
/
Thank you for your articles. They are very helpful to me. May I ask you a question? http://www.hairstylesvip.com
Thank you for your help and this post. It’s been great. http://www.kayswell.com
This is my first time pay a quick visit at here and i am really happy to read everthing at one place
This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!
Good post! We will be linking to this particularly great post on our site. Keep up the great writing
I’m often to blogging and i really appreciate your content. The article has actually peaks my interest. I’m going to bookmark your web site and maintain checking for brand spanking new information.
I very delighted to find this internet site on bing, just what I was searching for as well saved to fav
Okay, trying out 122betvip. Feeling like a VIP already! The deposit bonuses are pretty nice, but make sure to read the terms and conditions, guys. Good luck to all!! 🙂
Abetpix365bonus… now we’re talking bonuses! I’m always on the hunt for a good promo. Worth checking out if you’re looking for some extra bang for your buck. Here’s abetpix365bonus for you!