Home » RDBMS Server » Server Administration » performance tuning redo logs (10g standard)
icon5.gif  performance tuning redo logs (10g standard) [message #222084] Thu, 01 March 2007 13:02 Go to next message
akimeu
Messages: 5
Registered: March 2007
Junior Member
We all know about the new fast_start_mttr_target parameter, which helps in tuning the redo logs. But Oracle Standard edition, does not support this parameter. I'd welcome your thoughts on how to accomplish the same thing - but without the fast_start_mttr_target parameter.

Thanks in advance.

Alex
Re: performance tuning redo logs (10g standard) [message #222086 is a reply to message #222084] Thu, 01 March 2007 13:08 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
HUH?
IMO, whether it exists or not is NOT Edition related, but it could be version related.

It exists for me on Standard Edition.

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 1 11:05:42 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> show parameter fast_start_mttr_target;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target integer 0
Re: performance tuning redo logs (10g standard) [message #222088 is a reply to message #222086] Thu, 01 March 2007 13:11 Go to previous messageGo to next message
akimeu
Messages: 5
Registered: March 2007
Junior Member
Try to set it to something other than 0...

I use 10.1.x
Re: performance tuning redo logs (10g standard) [message #222090 is a reply to message #222084] Thu, 01 March 2007 13:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> alter system set fast_start_mttr_target=1;
alter system set fast_start_mttr_target=1
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Fast-Start Fault Recovery

[Updated on: Thu, 01 March 2007 13:26] by Moderator

Report message to a moderator

Re: performance tuning redo logs (10g standard) [message #222098 is a reply to message #222090] Thu, 01 March 2007 14:59 Go to previous messageGo to next message
akimeu
Messages: 5
Registered: March 2007
Junior Member
That's weird!

SQL> alter system set fast_start_mttr_target=1800;
alter system set fast_start_mttr_target=1800
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Fast-Start Fault Recovery

I looked it up on the net, and it said in a blog that the feature may not be available. But, this seem to have worked. Thanks for the eye opener.

SQL> alter system set fast_start_mttr_target=1800 scope=spfile;

System altered.
Re: performance tuning redo logs (10g standard) [message #222180 is a reply to message #222084] Fri, 02 March 2007 03:18 Go to previous message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
Hi,

u should check the following Dynamic initialization parameters:

LOG_CHECKPOINT_TIMEOUT
LOG_CHECKPOINT_INTERVAL


& if u want to log checkpoint info. in the alert log u can utilize the

LOG_CHECKPOINTS_TO_ALERT

Looking for your feedback,
Regards,

Sunny
Previous Topic: How to Find the Temporary Tables
Next Topic: New Oracle 10g processes
Goto Forum:
  


Current Time: Sat Dec 10 11:04:10 CST 2016

Total time taken to generate the page: 0.09651 seconds