OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Redo log size

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

Redo log size [message #180237]

Sat, 01 July 2006 03:27

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

Hi all

I have a Production Database of size 190 GB having 3 redo groups . What sould be the redo log group size.

--- No Idea about Transaction Rate bcz we r just going to put this database in production.

Thanks in advance

Report message to a moderator

Re: Redo log size [message #180243 is a reply to message #180237]

Sat, 01 July 2006 08:27

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

There is no standard redo log size and it depends on several factors :

-- No. of transactions
-- Backup strategy
-- Archive log mode etc..

It's good to estimate and then size your redo logs.

Report message to a moderator

Re: Redo log size [message #180249 is a reply to message #180237]

Sat, 01 July 2006 16:07

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

And I'd say increase your number of redo log groups from 3 to some higher number. At least double...

Report message to a moderator

Previous Topic:	ANALYZE_SCHEMA questions
Next Topic:	add partition and values Partition errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:19:14 CDT 2024