怎么监控oracle数据库表和表空间

怎么监控oracle数据库表和表空间的现状

declare

unf number;

unfb number;

fs number;

fsb number;

fs number;

fsb number;

fs number;

fsb number;

fs number;

fsb number;

full number;

fullb number;

begin

dbms_spacespace_usage(&

&

TABLE

unf

unfb

fs

fsb

fs

fsb

fs

fsb

fs

fsb

full

fullb);

dbms_outputput_line(unformatted_blocks: || unf);

dbms_outputput_line(full_blocks(% free): || full);

dbms_outputput_line(fs_blocks(% free): || fs);

dbms_outputput_line(fs_blocks(% free): || fs);

dbms_outputput_line(fs_blocks(% free): || fs);

dbms_outputput_line(fs_blocks(% free): || fs);

end;

/

表空间的使用历史记录(只输出了每天的第一次统计结果)

select bname

artime

atablespace_usedsize

atablespace_size

round( * atablespace_usedsize / atablespace_size) used_percent

from dba_hist_tbspc_space_usage a

(select tname

min(rtime) rtime

min(tablespace_id) tablespace_id

from dba_hist_tbspc_space_usage t

inner join v$tablespace t on ttablespace_id = tTS#

where tNAME = upper(&)

group by name substr(rtime)

) b

where atablespace_id = btablespace_id

and artime = brtime

order by artime;

表的剩余空间预测

select * from table(dbms_spaceOBJECT_GROWTH_TREND(ECC_CC YTKC_ORDERRELEVANCE TABLE)