ORACLE DBA系统维护手册

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