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 :: Show 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: 81
Registered: June 2008
Location: MGL

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: 20108
Registered: January 2009

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: 81
Registered: June 2008
Location: MGL

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: 54226
Registered: March 2007
Location: Nanterre, France, http://...

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: Fri May 24 06:35:50 CDT 2013

Total time taken to generate the page: 0.16552 seconds