Oracle数据库系统巡检报告

ndstatus<>'VALID';norowsselected查找失效的约束SQL>SELECTowner,constraint_name,table_name,constraint_type,statusFROMdba_constraintsWHEREstatus='DISABLE'andconstraint_type='P';norowsselected查找失效的触发器SQL>setline200;settable_nameformata30;SELECTowner,trigger_name,table_name,statusFROMdba_triggersWHEREstatus='DISABLED';SQL>SP2-0158:unknownSEToption"table_name"SQL>OWNER TRIGGER_NAME TABLE_NAME STATUS--------------------------------------------------------------------------------------------------SYS LOGMNRGGC_TRIGGER DISABLEDWMSYS NO_VM_DDL DISABLEDWMSYS NO_VM_DROP_A DISABLED使用AWR收集实例信息使用oracle用户登录,在sqlplus中使用ORACLEAWR收集工作时间段的性能数据。缺省设置时AWR可以收集7天以内的历史信息。[oracle@xtbgdb1~]$sqlplus/assysdbaSQL>@?/rdbms/admin/......Entervalueforreport_type:TypeSpecified:html......Specifythenumberofdaysofsnapshotstochoosefrom