SQL>
select a.* from (
select S.SNAP_ID,
T.NAME,
S.RTIME,TABLESPACE_USEDSIZE
fromV$TABLESPACE T, DBA_HIST_TBSPC_SPACE_USAGE S
where T.TS# = S.TABLESPACE_ID
and T.name = 'MIT22007' order by SNAP_ID desc) a
where rownum 2345678
9;
SNAP_ID NAME
RTIME
TABLESPACE_USEDSIZE
---------- ------------------------------ ------------------------- -------------------
3064 MIT22007
08/13/2008 03:01:05
23563424
SQL> SELECT a.tablespace_name,
b.size_kb,
a.free_kb,b.size_kb-a.free_kb "USED_DB",
Trunc((a.free_kb/b.size_kb) * 100) "FREE_%"
FROM (SELECT tablespace_name,
Trunc(Sum(bytes)/1024) free_kb
FROM dba_free_space
GROUP BY tablespace_name) a,
(SELECT tablespace_name,
Trunc(Sum(bytes)/1024) size_kb
FROM dba_data_files
GROUP BY tablespace_name) b
WHEREa.tablespace_name = b.tablespace_name and a.tablespace_name='MIT22007';23456789 10 11 12 13
TABLESPACE_NAME
SIZE_KBFREE_KBUSED_DB FREE_%
------------------------------ ---------- ---------- ---------- ----------
MIT22007
256000000 62282432193717568 24
这两个视图的TABLESPACE_USEDSIZE和USED_DB怎么会差这么大?这个表空间只会向上涨,不会删资料的.所以只有可能DBA_HIST_TBSPC_SPACE_USAGE 的TABLESPACE_USEDSIZE会比USED_DB小.这里就奇怪了??
|