利用SQL语句实现数据库性能监控
;alter tablespace name coalesce;alter table name deallocate unused;create or replace view ts_blocks_v as selecttablespace_name,block_id,bytes,blocks, gment_name fromdba_free_space union all select tablespace_name, block_id,bytes, blocks, segment_name from dba_extents;select * from ts_blocks_v;select tablespace_name,sum(bytes),max(bytes),count(block_id)fr
<<上一页 下一页>>
广州市越秀区图书馆版权所有。
联系电话:020-87673002
本站访问人数: