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: 50
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.
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: 60018
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
Previous Topic: enable/ disable row movement
Next Topic: My question about compressing table
Goto Forum:
  


Current Time: Mon Dec 22 19:06:34 CST 2014

Total time taken to generate the page: 0.08102 seconds