OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Sizing arch-redos

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

Sizing arch-redos [message #109395]

Thu, 24 February 2005 02:01

AL
Messages: 24
Registered: October 2000

Junior Member

Hello,

I have a 8.1.7.-db on an w2000-server.
The redos have a size of 1 mb. This is too small.
In the prime-time there are over 10 redo-switches and in the other times about 5.
Now I have the plan to oversize them (e.g. 100 mb) and execute an 'alter system switch logfile' 2 or 3 times per hour.
Can anybody comment this idea? Make this sense or do I overlook anythig?

Report message to a moderator

Re: Sizing arch-redos [message #109402 is a reply to message #109395]

Thu, 24 February 2005 06:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>execute an 'alter system switch logfile' 2 or 3 times per hour.
why are you planning to do this?

Report message to a moderator

Re: Sizing arch-redos [message #109723 is a reply to message #109402]

Mon, 28 February 2005 02:16

alfie
Messages: 5
Registered: February 2005

Junior Member

I want to achive the redo-logs every 20 minutes like oracle recommends.
Without this "trick" I have either too much log switches (and so a lot to write for the db) or too less (and so I am not able to recover exactly!) ; depending on the size of the redo-logs.

Report message to a moderator

Re: Sizing arch-redos [message #109751 is a reply to message #109723]

Mon, 28 February 2005 10:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I beleive you are on the right track.
Only in 9i oracle has introduced the parameter
ARCHIVE_LAG_TARGET
to help this.
Regards

Report message to a moderator

Previous Topic:	Tablespace query
Next Topic:	Problem with Oracle 8i silent install (8.1.7.4)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:15:04 CST 2025