Home » RDBMS Server » Server Administration » archive log generation time interval or size wise (oracle 10g solaris 10)
archive log generation time interval or size wise [message #528014] Fri, 21 October 2011 04:29 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
i am using oracle 10g on solaris 10 os.
currently archived log is generated by size wise 52 mb.
i want to know whar is the best practice for archive log generation . it should be time interval or size wise.

Report message to a moderator

Re: archive log generation time interval or size wise [message #528019 is a reply to message #528014] Fri, 21 October 2011 04:54 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A number of switches of 4 to 6 per hour is good rule of thumb.

Regards
Michel

Report message to a moderator

Previous Topic: enable/ disable row movement
Next Topic: My question about compressing table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:53:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.