查看Oracle数据库状态
1 查看数据库组件
column comp_id format a15
column comp_name format a45
column version format a15
column status format a10
set linesize 300
set pagesize 1000
select comp_id,comp_name,version,status from dba_registry;
SQL> column comp_id format a15
SQL> column comp_name format a45
SQL> column version format a15
SQL> column status format a10
SQL> set linesize 300
SQL> set pagesize 1000
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
--------------- --------------------------------------------- --------------- ----------
OWB OWB 11.2.0.4.0 VALID
APEX Oracle Application Express 3.2.1.00.12 VALID
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
EXF Oracle Expression Filter 11.2.0.4.0 VALID
RUL Oracle Rules Manager 11.2.0.4.0 VALID
OWM Oracle Workspace Manager 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID
RAC Oracle Real Application Clusters 11.2.0.4.0 VALID
19 rows selected.
2 查看数据库默认用户
column username format a20
column account_status format a25
set linesize 300
set pagesize 1000
select username,account_status from dba_users;
SQL> column username format a20
SQL> column account_status format a25
SQL> set linesize 300
SQL> set pagesize 1000
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
-------------------- -------------------------
SYS OPEN
SYSTEM OPEN
OUTLN EXPIRED & LOCKED
MGMT_VIEW EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DBSNMP EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
APPQOSSYS EXPIRED & LOCKED
APEX_030200 EXPIRED & LOCKED
OWBSYS_AUDIT EXPIRED & LOCKED
ORDDATA EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
ANONYMOUS EXPIRED & LOCKED
SYSMAN EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
OWBSYS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
SCOTT EXPIRED & LOCKED
ORACLE_OCM EXPIRED & LOCKED
XS$NULL EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
APEX_PUBLIC_USER EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED
R
SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED
R
30 rows selected.
SQL>
3 查看数据库字符集
查看结果：
NLS_CHARACTERSET: ZHS16GBK ，NLS_NCHAR_CHARACTERSET: AL16UTF16
column parameter format a30
column value format a30
set linesize 300
set pagesize 1000
select * from v$nls_parameters
where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');
SQL> column parameter format a30
SQL> column value format a30
SQL> set linesize 300
SQL> set pagesize 1000
SQL> select * from v$nls_parameters
2 where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');
PARAMETER VALUE
------------------------------ ------------------------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
SQL>
4 查看数据库参数：
查看结果为：
db_block_size: 8192
processes: 3000
open_cursors: 3000
sec_case_sensitive_logon: false
column name format a30
column value format a10
set linesize 300
set pagesize 1000
select name,value from v$parameter
where name in ('db_block_size','processes', 'open_cursors','sec_case_sensitive_logon');
SQL> column name format a30
SQL> column value format a10
SQL> set linesize 300
SQL> set pagesize 1000
SQL> select name,value from v$parameter
2 where name in ('db_block_size','processes', 'open_cursors','sec_case_sensitive_logon');
NAME VALUE
------------------------------ ----------
processes 150
db_block_size 8192
sec_case_sensitive_logon TRUE
open_cursors 300
SQL>
5 查看oracle 用户密码策略
查看结果： 均为unlimited
column resource_name format a30
column limit format a20
set linesize 300
set pagesize 1000
select resource_name,limit from dba_profiles
where profile='DEFAULT'
and resource_name in ('FAILED_LOGIN_ATTEMPTS','PASSWORD_LIFE_TIME');
SQL> column resource_name format a30
SQL> column limit format a20
SQL> set linesize 300
SQL> set pagesize 1000
SQL> select resource_name,limit from dba_profiles
2 where profile='DEFAULT'
3 and resource_name in ('FAILED_LOGIN_ATTEMPTS','PASSWORD_LIFE_TIME');
RESOURCE_NAME LIMIT
------------------------------ --------------------
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
SQL>
6 查看重做日志情况
Group: 3
Member: 2
Size: 500M
select group#,members,(bytes/1024/1024)||'M' bytes from v$log;
SQL> select group#,members,(bytes/1024/1024)||'M' bytes from v$log;
GROUP# MEMBERS BYTES
---------- ---------- ----------------------------------------------------------------------------------
1 2 50M
2 2 50M
3 2 50M
4 2 50M
SQL>
查看Oracle数据库状态
-
Michael_DD
2014-11-25 15:29:30 -
Oracle
- 原创