OraFAQ Forum: Performance Tuning » Just clarification my mind about redo log file size

Home » RDBMS Server » Performance Tuning » Just clarification my mind about redo log file size (Oracle 10G)

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

Just clarification my mind about redo log file size [message #502333]

Wed, 06 April 2011 00:01

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hi all,

The REDO log file size is important DB performance issues when DB is run archivelog mode.

If DB run noarchivelog mode, REDO log file size not impact to DB performance.

Am I correct?

Report message to a moderator

Re: Just clarification my mind about redo log file size [message #502335 is a reply to message #502333]

Wed, 06 April 2011 00:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Am I correct?
NO

post reproducible benchmark that supports your assertion.

Report message to a moderator

Re: Just clarification my mind about redo log file size [message #502342 is a reply to message #502335]

Wed, 06 April 2011 01:05

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hi BlackSwan

I don't catch your post.
Could you please clarify little more detail your reply?

Report message to a moderator

Re: Just clarification my mind about redo log file size [message #502349 is a reply to message #502342]

Wed, 06 April 2011 01:16

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The redo log size is important in both cases.

Regards
Michel

Report message to a moderator

Previous Topic:	please help me tune this query
Next Topic:	how to use index on "ON in MERGE statement"?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:43:32 CST 2024