ORACLE DBA系統維護手冊

一.資料庫日常巡檢

1.表空間巡檢

SELECT Upper(f.Tablespace_Name) “表空間名”

,d.Tot_Grootte_Mb “表空間大小(M)”

,d.Tot_Grootte_Mb - f.Total_Bytes “已使用空間(M)”

,To_Char(Round((d.Tot_Grootte_Mb - f.Total_Bytes) / d.Tot_Grootte_Mb * 100, 2), ‘990.99’) “使用比”

,f.Total_Bytes “空閑空間(M)”

,f.Max_Bytes “最大塊(M)”

FROM (SELECT Tablespace_Name

,Round(SUM(Bytes) / (1024 * 1024), 2) Total_Bytes

,Round(MAX(Bytes) / (1024 * 1024), 2) Max_Bytes

FROM Sys.Dba_Free_Space

GROUP BY Tablespace_Name) f

,(SELECT Dd.Tablespace_Name

,Round(SUM(Dd.Bytes) / (1024 * 1024), 2) Tot_Grootte_Mb

FROM Sys.Dba_Data_Files Dd

GROUP BY Dd.Tablespace_Name) d

WHERE d.Tablespace_Name = f.Tablespace_Name

ORDER BY 4 DESC;

二.資料庫啟停

1.監聽啟停操作

lsnrctl status LISTENER

lsnrctl start LISTENER

lsnrctl stop LISTENER

2.資料庫啟停操作

sqlplus / as sysdba

shutdwon immediate;

shutdown abort

startup