Re: archivelog performance issues

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: jachang@xxxxxxxx
  • Date: Tue, 7 Jul 2009 09:52:02 -0700

On Tue, Jul 7, 2009 at 9:06 AM, Julio Aguilar-Chang <jachang@xxxxxxxx>wrote:

> Is there a good reason based on performance for not enabling archivelog
> mode?

My first reaction to that is 'forget about performance'.

You should probably ask the business owners if they can afford to lose all
transactions after the most recent backup.

Because at some point, all systems need to be recovered.

And if the most recent backup is corrupt, they will lose all transactions
back to the previous backup.

I know how I would answer that if it were my business.

After they tell you to implement archive logging ASAP, you
can monitor for performance by asking the users if performance
is still acceptable.

Others have already given good advice on log sizing.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: