Installing, Executing and Interpreting output from the "scnhealthcheck.sql" script (文档 ID 1393363.1)中提到对scn的增长与检查。

Patch:13498243中有此脚本，下面把脚本放出来了。

RemRem$Header:rdbms/admin/scnhealthcheck.sqlapfwkr_blr_backport_13498243_12.1.0.2.0/12015/05/2622:44:51apfwkrExp$RemRemscnhealthcheck.sqlRemRemCopyright(c)2012,2015,Oracleand/oritsaffiliates.RemAllrightsreserved.RemRemNAMERemscnhealthcheck.sql-ScnHealthcheckRemRemDESCRIPTIONRemChecksscnhealthofaDBRemRemNOTESRem.RemRemMODIFIED(MM/DD/YY)Remtbhukya01/11/12-CreatedRemRemdefineLOWTHRESHOLD=10defineMIDTHRESHOLD=62defineVERBOSE=FALSEsetverioff;setfeedbackoff;setserveroutonDECLAREverboseboolean:=&&VERBOSE;BEGINForCin(selectversion,date_time,dbms_flashback.get_system_change_numbercurrent_scn,indicatorfrom(selectversion,to_char(SYSDATE,'YYYY/MM/DDHH24:MI:SS')DATE_TIME,((((((to_number(to_char(sysdate,'YYYY'))-1988)*12*31*24*60*60)+((to_number(to_char(sysdate,'MM'))-1)*31*24*60*60)+(((to_number(to_char(sysdate,'DD'))-1))*24*60*60)+(to_number(to_char(sysdate,'HH24'))*60*60)+(to_number(to_char(sysdate,'MI'))*60)+(to_number(to_char(sysdate,'SS'))))*(16*1024))-dbms_flashback.get_system_change_number)/(16*1024*60*60*24))indicatorfromv$instance))LOOPdbms_output.put_line('-----------------------------------------------------'||'---------');dbms_output.put_line('ScnHealthCheck');dbms_output.put_line('-----------------------------------------------------'||'---------');dbms_output.put_line('CurrentDate:'||C.date_time);dbms_output.put_line('CurrentSCN:'||C.current_scn);if(verbose)thendbms_output.put_line('SCNHeadroom:'||round(C.indicator,2));endif;dbms_output.put_line('Version:'||C.version);dbms_output.put_line('-----------------------------------------------------'||'---------');IFC.version>'10.2.0.5.0'andC.versionNOTLIKE'9.2%'THENIFC.indicator>&MIDTHRESHOLDTHENdbms_output.put_line('Result:A-SCNHeadroomisgood');dbms_output.put_line('Applythelatestrecommendedpatches');dbms_output.put_line('basedonyourmaintenanceschedule');IF(C.version<'11.2.0.2')THENdbms_output.put_line('ANDset_external_scn_rejection_threshold_hours='||'24afterapply.');ENDIF;ELSIFC.indicator<=&LOWTHRESHOLDTHENdbms_output.put_line('Result:C-SCNHeadroomislow');dbms_output.put_line('Ifyouhavenotalreadydonesoapply');dbms_output.put_line('thelatestrecommendedpatchesrightnow');IF(C.version<'11.2.0.2')THENdbms_output.put_line('set_external_scn_rejection_threshold_hours=24'||'afterapply');ENDIF;dbms_output.put_line('ANDcontactOraclesupportimmediately.');ELSEdbms_output.put_line('Result:B-SCNHeadroomislow');dbms_output.put_line('Ifyouhavenotalreadydonesoapply');dbms_output.put_line('thelatestrecommendedpatchesrightnow');IF(C.version<'11.2.0.2')THENdbms_output.put_line('ANDset_external_scn_rejection_threshold_hours='||'24afterapply.');ENDIF;ENDIF;ELSEIFC.indicator<=&MIDTHRESHOLDTHENdbms_output.put_line('Result:C-SCNHeadroomislow');dbms_output.put_line('Ifyouhavenotalreadydonesoapply');dbms_output.put_line('thelatestrecommendedpatchesrightnow');IF(C.version>='10.1.0.5.0'andC.version<='10.2.0.5.0'andC.versionNOTLIKE'9.2%')THENdbms_output.put_line(',set_external_scn_rejection_threshold_hours=24'||'afterapply');ENDIF;dbms_output.put_line('ANDcontactOraclesupportimmediately.');ELSEdbms_output.put_line('Result:A-SCNHeadroomisgood');dbms_output.put_line('Applythelatestrecommendedpatches');dbms_output.put_line('basedonyourmaintenanceschedule');IF(C.version>='10.1.0.5.0'andC.version<='10.2.0.5.0'andC.versionNOTLIKE'9.2%')THENdbms_output.put_line('ANDset_external_scn_rejection_threshold_hours=24'||'afterapply.');ENDIF;ENDIF;ENDIF;dbms_output.put_line('ForfurtherinformationreviewMOSdocumentid1393363.1');dbms_output.put_line('-----------------------------------------------------'||'---------');ENDLOOP;end;/