oracleϵͳ±í¿Õ¼äsystemºÍsysauxʹÓÃÂʺܸß

ʹÓÃ
set
pagesize 1000
set
linesize 132
col
TS_NAME form a24
col
PIECES form 9999
col
PCT_FREE form 999.9
col
PCT_USED form 999.9
select
*
 
from (select Q2.OTHER_TNAME TS_NAME,
              
PIECES,
              
TS_SIZE TS_SIZE,
              
NVL(LARGEST_CHUNK, 0) LARGESTPC,
              
NVL(TOTAL_FREE, 0) TOTALFREE,
              
NVL(ROUND((TOTAL_FREE / TS_SIZE)
* 100, 2), 0) PCT_FREE,
              
TS_SIZE - TOTAL_FREE WHATSUSED,
              
NVL(100 - ROUND((TOTAL_FREE /
TS_SIZE) * 100, 2), 100) PCT_USED,
              
decode(nvl(100-round((total_free/ts_size)*100,0),100),
                
85,'+',86,'+',87,'+',88,'+',89,'++',90,'++',91,'++',
                
92,'++',93,'++',94,'+++',95,'+++',96,'+++',97,'++++',
                
98,'+++++',99,'+++++',100,'+++++','')
PROBLEM
         
from (select DFS.TABLESPACE_NAME,
                      
count(*) PIECES,
                &n