Database Tuning (MOSC)

MOSC Banner

incremental shipping for standby databases

edited Jan 17, 2012 4:32AM in Database Tuning (MOSC) 1 commentAnswered
Hi,

I am getting the following message in my ADDM report.Can anyone tell me what does this mean?What is incremental shipping?

Finding 3: Log File Switches
Impact is .04 active sessions, 3.26% of total activity.
-------------------------------------------------------
Log file switch operations were consuming significant database time while
waiting for checkpoint completion.
This problem can be caused by use of hot backup mode on tablespaces.  DML to tablespaces in hot backup mode causes generation of additional redo.

   Recommendation 1: Database Configuration
   Estimated benefit is .04 active sessions, 3.26% of total activity.
   ------------------------------------------------------------------
   Action
      Verify whether incremental shipping was used for standby databases.

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center