ORACLE 日常维护手册
查看数据库版本
SELECT * FROM V$VERSION;
查看数据库语言环境
SELECT USERENV('LANGUAGE') FROM DUAL;
查看ORACLE...INSTANCE_NAME,HOST_NAME,STARTUP_TIME,STATUS,DATABASE_STATUS
FROM V$INSTANCE;
查看ORACLE监听状态
lsnrctl status
查看数据库归档模式...CONSTRAINT_NAME, TABLE_NAME, CONSTRAINT_TYPE, STATUS
FROM DBA_CONSTRAINTS
WHERE STATUS = 'DISABLE';
检查发生坏块的数据库对象...DBA_EXTENTS
WHERE FILE_ID =
AND BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
检查无效的数据库对象...SELECT * FROM DBA_JOBS_RUNNING;
检查数据库JOB的完成情况
SELECT JOB, LOG_USER, LAST_DATE, NEXT_DATE, WHAT, FAILURES