OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Redo Log File (Oracle 9i)

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

Redo Log File [message #282771]

Fri, 23 November 2007 06:52

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.

Report message to a moderator

Re: Redo Log File [message #282774 is a reply to message #282771]

Fri, 23 November 2007 06:58

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

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

Report message to a moderator

Re: Redo Log File [message #282835 is a reply to message #282771]

Sat, 24 November 2007 01:33

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.

Report message to a moderator

Re: Redo Log File [message #282837 is a reply to message #282835]

Sat, 24 November 2007 01:38

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.

Report message to a moderator

Re: Redo Log File [message #282933 is a reply to message #282835]

Sun, 25 November 2007 03:43

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

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

Report message to a moderator

Re: Redo Log File [message #282991 is a reply to message #282771]

Sun, 25 November 2007 21:54

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.

Report message to a moderator

Re: Redo Log File [message #282993 is a reply to message #282771]

Sun, 25 November 2007 22:02

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Creating Backup Job with DBMS_SCHEDULER
Next Topic:	RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 08 13:20:19 CDT 2025