We're here to help!

Speeding Up the Log Apply Process

Follow
Description

The speed of applying the logs on the secondary server is dictated by Oracle. Dbvisit Standby uses the Oracle engine to apply the archive logs.

Solution

gather stats will not make a difference to the process as the apply process is not going through the SQL engine but adding the data directly to lower levels of the database.

Oracle uses the SGA (database memory cache) on the standby database to apply the changes. We recommend increasing the SGA, to speed up the recovery because more of the changes can be cached (and reused). To increase the SGA size, please increase the db_cache_size parameter on the standby database.

Please also see the following on recovery parallelism:

http://support.dbvisit.com/hc/en-us/articles/216840787

And some of the general Dbvisit Standby performance tuning options are worth reviewing:

https://dbvisit.atlassian.net/wiki/display/UGDS7/Performance+Tuning+Options

Mike Donovan August 04, 2014 12:06

Have more questions? Submit a request

Comments