使用
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
row_number() OVER (PARTITION BY COL1 ORDER BY COL2) 表示根据COL1分组，在分组内部根据 COL2排序，而此函数计算的值就表示每组内部排序后的顺序编号（组内连续的唯一的).
与rownum的区别在于：使用rownum进行排序的时候是先对结果集加入伪列rownum然后再进行排序，而此函数在包含排序从句后是先排序再计算行号� ......
