ITPub博客

1. 表空间剩余空间SELECT tablespace_name, sum ( blocks ) as free_blk , trunc ( sum ( bytes ) /(1024*1024) ) as free_m, max ( bytes ) / (1024) as big_chunk_k, count (*) as num_chunksFROM dba_free_spaceGROUP BY tablespace_nameSELECT * FROM dba_tablespace_usage_metrics;2. 表空间数据量情况显示SELECT tablespace_name, max_blocks, count_blocks, sum_free_blocks, to_char(100*sum_free_blocks/sum_alloc_blocks, '99.99') || '%' AS pct_freeFROM ( SELECT tablespace_name, sum(blocks) AS sum_alloc_blocksFROM db

该死遇到这样错误http://www.itpub.net/thread-1418178-1-1.html[@more@]

2011-4-7 正式开通blog[@more@]开通blog ，分享我自己IT数据这块成长的点点滴滴