Re: Database performance during hot backup
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Fri, 30 Mar 2012 10:16:01 -0500 (CDT)
Message-ID: <bca251d6841ceaa76df55efc12aff4e2.squirrel_at_society.servebeer.com>
Hi Amir,
Date: Fri, 30 Mar 2012 10:16:01 -0500 (CDT)
Message-ID: <bca251d6841ceaa76df55efc12aff4e2.squirrel_at_society.servebeer.com>
Hi Amir,
> I am trying to understand if it is expected to see performance
> degradation of DML transactions that are active during a hot backup. It
> is my understanding that the only noticeable thing that happens during a
> hot backup for DML statement is an increase in the amount of redo
> generation and that is because Oracle starts to log full images of data
> blocks before a change is made to a data block. I am not aware of any
> impact on performance while in hot backup mode, unless the LGWR is being
> constrained for some reason.
My kneejerk is two things:
- The hot backup will certainly use system resources, especially IO. If your instance is heavy on IO or IO-bound, then the possibly significant IO load of the backup would likely impact Oracle transactions.
- You may want to consider using RMAN instead of the traditional hot backup.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 30 2012 - 10:16:01 CDT