Home » RDBMS Server » Performance Tuning » Just clarification my mind about redo log file size (Oracle 10G)
Just clarification my mind about redo log file size [message #502333] Wed, 06 April 2011 00:01 Go to next message
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?
Re: Just clarification my mind about redo log file size [message #502335 is a reply to message #502333] Wed, 06 April 2011 00:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Am I correct?
NO

post reproducible benchmark that supports your assertion.
Re: Just clarification my mind about redo log file size [message #502342 is a reply to message #502335] Wed, 06 April 2011 01:05 Go to previous messageGo to next message
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?
Re: Just clarification my mind about redo log file size [message #502349 is a reply to message #502342] Wed, 06 April 2011 01:16 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The redo log size is important in both cases.

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


Current Time: Thu Mar 28 10:19:20 CDT 2024