ORACLE性能优化练习.pptVIP

1.表空间使用情况：set linesize 200set pagesize 200select a.tablespace_name,a.bytes/1024/1024 Sum MB,(a.bytes-b.bytes)/1024/1024 used MB,b.bytes/1024/1024 free MB,round(((a.bytes-b.bytes)/a.bytes)*100,2) percent_usedfrom (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a,??? (select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name) b??? where a.tablespace_name=b.tablespace_name??? order by ((a.bytes-b.bytes)/a.bytes) desc; 2.监控FRA空间使用率 SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable)FRO