数据库基础环境查看

数据库基础环境查看

.

分类：oracle2011-02-18 14:3656人阅读评论(0)收藏举报

select * from v$version;

select * from dba_registry_database;

select instance_name,host_name,version,status,database_status from v$instance; selectdbms_utility.port_string from dual;

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

select * from dba_registry;

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

selectprotection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status

fromv$database;

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

selectlog_mode from v$database;

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

selectflashback_on from v$database;

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

selectforce_logging,supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui,

supplemental_log_data_fk, supplemental_log_data_all

fromv$database;

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

select * from v$controlfile; --------控制文件的组成；

selectl.group#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, lf.status LOGFILE_STATUS fromv$log l, v$logfile lf

wherel.group# = lf.group#

order by 1,3; -------------REDO LOG日志文件

select owner, object_type, COUNT(*)

fromdba_objects

where status = 'INVALID'

group by owner, object_type; ---------数据库中无效对象

selectname,phyrds,phywrts,readtim,writetim

fromv$filestata,v$dbfile b

wherea.file# = b.file#

order by readtimdesc ----------查看频繁读写的表空间