OraFAQ Forum: Server Administration » performance tuning redo logs (10g standard)

Home » RDBMS Server » Server Administration » performance tuning redo logs (10g standard)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

performance tuning redo logs (10g standard) [message #222084]

Thu, 01 March 2007 13:02

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

Report message to a moderator

Re: performance tuning redo logs (10g standard) [message #222086 is a reply to message #222084]

Thu, 01 March 2007 13:08

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: performance tuning redo logs (10g standard) [message #222088 is a reply to message #222086]

Thu, 01 March 2007 13:11

akimeu
Messages: 5
Registered: March 2007

Junior Member

Try to set it to something other than 0...

I use 10.1.x

Report message to a moderator

Re: performance tuning redo logs (10g standard) [message #222090 is a reply to message #222084]

Thu, 01 March 2007 13:23

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

Re: performance tuning redo logs (10g standard) [message #222180 is a reply to message #222084]

Fri, 02 March 2007 03:18

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:39:05 CST 2024