DBA常用sql语句

1.
select sql_text,hash_value,executions,loads,invalidations
from v$sqlarea

2.
select group#,sequence#,status from v$log;

3.切换当前log file
alter system switch logfile;

4.强制执行检查点
alter system checkpoint;

5.查看当前归档模式
archive log list;

6.
desc v$bgprocess

7.
select paddr,pserial#,name,description
from v$bgprocess where paddr != '00'

8.
alter database archivelog;