Home » RDBMS Server » Backup & Recovery » Redo Log File (Oracle 9i)
Redo Log File [message #282771] Fri, 23 November 2007 06:52 Go to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Friends,
Does increasing the number of redo log files has any impact on Database in any way?
Does it affect the overall performance or recovery performance?
Please help.
Re: Redo Log File [message #282774 is a reply to message #282771] Fri, 23 November 2007 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Maybe yes, maybe no, it depends but it does not hurt.
2/ Maybe yes, maybe no, it depends but it does not hurt.
3/ No.

Regards
Michel
Re: Redo Log File [message #282835 is a reply to message #282771] Sat, 24 November 2007 01:33 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Thanks for your highly philosophical answer.But i am very poor in philosophy.
I will be grateful to u if you could give me technical answer.
Re: Redo Log File [message #282837 is a reply to message #282835] Sat, 24 November 2007 01:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

I will be grateful to u if you could give me technical answer.
then provide us technical information.

1. All is depends on condition.
Re: Redo Log File [message #282933 is a reply to message #282835] Sun, 25 November 2007 03:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I could give a more accurate answer, if you post a more precise question.
You posted a general question, you get a general answer.

The answer depends on your workoad, you storage, your cpu and so on.

Regards
Michel
Re: Redo Log File [message #282991 is a reply to message #282771] Sun, 25 November 2007 21:54 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
I think it would have been better to provide the answer precisely rather than posting replies after replies and providing philosophical lectures.
Re: Redo Log File [message #282993 is a reply to message #282771] Sun, 25 November 2007 22:02 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I think it would have been better to provide the answer precisely rather than posting replies after replies and providing philosophical lectures.
You are entitled to your opinion.
We are entitled to our own opinions.
You don't know, what you don't know.

>Does increasing the number of redo log files has any impact on Database in any way?
It depends.
>Does it affect the overall performance or recovery performance?
It depends.

Both responses directly above are PRECISE & CORRECT.
If you disagree, post different answers & test cases.
Previous Topic: Creating Backup Job with DBMS_SCHEDULER
Next Topic: RMAN
Goto Forum:
  


Current Time: Sat Dec 03 21:59:16 CST 2016

Total time taken to generate the page: 0.10298 seconds