SQL Script Fast Start MTTR settings

Updated: 20-Jul-2004
Version: 1.0

Description

Displays the settings of the MTTR. Also displays the new 10g feature of optimal redo size.

Parameters

None

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, writes_mttr, writes_logfile_size, optimal_logfile_size 
from v$instance_recovery
/

spool off

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