SQL Script Fast Start MTTR settings

Updated: 24-Nov-2004
Version: 1.0

Description

Displays the settings of the MTTR.

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 


spool mttr.lst

show parameter mttr
show parameter log_check

PROMPT
PROMPT mttr parameter should be set, if not restart the instance

select target_mttr, estimated_mttr
from v$instance_recovery
/

spool off

Related Links

Oracle 10g: (SQL Script) Fast Start MTTR settings

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links