Scripts
-
编辑 删除
查询Oracle表空间使用率
col TABLESPACE_NAME for a20 col SUM_SPACE(M) for a20 col USED_SPACE(M) for a20 col USED_RATE(%) for a20 col FREE_SPACE(M) for a20 set linesize 140 set pagesize 100 SELECT D.TABLESPACE_NAME, SPACE || ‘M’ “SUM_SPACE(M)”, BLOCKS “SUM_BLOCKS”,&...
-
编辑 删除
查询Oracle 临时表空间使用情况
SELECT d.tablespace_name “Name”, TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),’99,999,990.900’) “Size (M)”, TO_CHAR(NVL(t.hwm, 0)/1024/1024,’99999999.999’) “HWM (M)”, TO_CHAR(NVL(t.hwm / a.bytes * 100, 0), ‘990.00’) “HWM % ” , TO_CHAR(NVL(t.bytes/1024/1024, 0),’9999...
