Thursday, November 16, 2006

Display tablespace usage

Thursday, November 16, 2006 Posted by Andre Broers 3 comments
This script shows the tablespace usage.
src: http://www.oracle-consultant.co.uk

 break on report  
 compute sum of tbs_size_mb on report  
 compute sum of used    on report  
 compute sum of avail    on report  
 column tsname    format a20     heading ‘Tablespace Name’  
 column tbs_size_mb format 999,999   heading ‘Size|(MB)’  
 column used     format 999,999   heading ‘Used|(MB)’  
 column avail    format 999,999   heading ‘Free|(MB)’  
 column used_visual format a11     heading ‘Used’  
 column pct_used   format 999     heading ‘% Used’  
 set linesize 1000  
 set trimspool on  
 set pagesize 32000  
 set verify  off  
 set feedback off  
 PROMPT  
 PROMPT *************************  
 PROMPT *** TABLESPACE STATUS ***  
 PROMPT *************************  
 SELECT  df.tablespace_name              tsname  
 ,    sum(df.bytes)/1024/1024           tbs_size_mb  
 ,    nvl(sum(e.used_bytes)/1024/1024,0)      used  
 ,    nvl(sum(f.free_bytes)/1024/1024,0)      avail  
 ,    rpad(’ ‘||rpad(’X',round(sum(e.used_bytes)  
 *10/sum(df.bytes),0), ‘X’),11,’-')      used_visual  
 ,    nvl((sum(e.used_bytes)*100)/sum(df.bytes),0) pct_used  
 FROM   sys.dba_data_files df  
 ,    (SELECT  file_id  
 ,    sum(nvl(bytes,0)) used_bytes  
 FROM   sys.dba_extents  
 GROUP BY file_id) e  
 ,    (SELECT  max(bytes) free_bytes  
 ,    file_id  
 FROM   dba_free_space  
 GROUP BY file_id) f  
 WHERE  e.file_id(+) = df.file_id  
 AND   df.file_id  = f.file_id(+)  
 GROUP BY df.tablespace_name  
 ORDER BY 6  
 /  
 clear breaks  

3 comments:

  1. More models in the adidas Originals archive will feature the popular EQT theme. Starting off the upcoming Fall adidas nmd season fresh is the adidas ZX Flux ‘EQT’.The adidas ZX Flux comes in a White and Sub Green color combination while shades of Off-White and Grey are also spotted. Through the uppers is a White nylon mesh while a terry liner and Black outsole is also Yeezy Boost 350 shown. Following is Green which hits the adidas branding on the tongue and Three Stripes down the sides. Other details include Grey around the heel, Off-White midsole and the adidas Equipment logo on the heel.Below you can check out more images of the adidas ZX Flux Yeezy Boost 350 Moonrock EQT. Currently they have started to arrive at adidas Originals retailers overseas like MATE. Expect more shops to have them in the coming weeks.
    The adidas Ultra Boost has landed at many retailers through the years and continues to sell-out. We have also seen a few adidas store variations of the shoes, but next to come will be fitting for the colder months. Next up is the adidas Ultra Boost ATR.ATR which stands for All Terrain will be the latest adidas Ultra Boost that will feature a weather appropriate build. While still using Primeknit yeezy boost 750 through the uppers, around the toe box that runs up the sides is a waterproof tapered. Other then that, you have your traditional look while featuring a White Boost midsole, heel counter and Continental outsole.Keep scrolling to check out two colorways of the adidas Ultra Boost Yeezy Boost 350 Turtle Dove ATR. Although a specific release date or retail price isn’t available,

    ReplyDelete