oracle10 sys 表空间_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,'+&#