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: 97
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?
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: 23188
Registered: January 2009
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: 97
Registered: June 2008
Location: MGL
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: 60062
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: Fri Dec 26 20:29:30 CST 2014

Total time taken to generate the page: 0.07864 seconds