数据库基础环境查看

select * from v$version;
select * from dba_registry_database;
select  instance_name,host_name,version,status,database_status from v$instance;
select dbms_utility.port_string from dual;

-----------查看数据版本

select * from dba_registry;

-----------查看数据库安装的组件

select protection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status
　　from v$database;

-----------是否配置了dataguard

select log_mode from v$database;

-----------查看数据库是否启用了归档模式；

select flashback_on from v$database;

-----------是否起用了flashback database特性

select force_logging,supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui,
　　supplemental_log_data_fk, supplemental_log_data_all
　　from v$database;

-----------是否启用了force logging和补充日志

select * from v$controlfile; --------控制文件的组成；
select l.group#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, lf.status LOGFILE_STATUS
　　from v$log l, v$logfile lf
　　where l.group# = lf.group#
　　order by 1,3; -------------REDO LOG日志文件

 

select owner, object_type, COUNT(*)
　　from dba_objects
　　where status = 'INVALID'
　　group by owner, object_type;        ---------数据库中无效对象

select name,phyrds,phywrts,readtim,writetim
from v$filestat a,v$dbfile b
where a.file# = b.file#
order by readtim desc              ----------查看频繁读写的表空间