Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Log-apply services require memory the shared pool


Chapter 23

begin sys.dbms_logmnr_d.set_tablespace('log_ts'); end;


create spfile from pfile;

The logical standby can be cloned from the primary either following a clean shut-down of the primary or while the primary database is up and running. If the primary is to remain up, the database Resource Manager must be running. This can be enabled using the following SQL:

Protecting Data Using Standby Databases


To ensure the fastest application of redo on the standby, log-apply services require memory in the shared pool, and the use of parallel query. By default, 25 percent of SGA memory on the standby is allocated for redo-apply operations. Therefore, considera-tion should be given to increasing the SGA on the standby instance compared with that on the primary. The APPLY_SET procedure in the DBMS_LOGSTDBY package is used to control resource allocation. The following command restricts the SGA usage for redo log application on the standby to the specified limit:



Creating the Logical Standby

The logical standby database must be based on a copy of the primary. This copy can be taken either following a clean shutdown of the primary (using either SHUTDOWN or SHUTDOWN IMMEDIATE) or while the primary database is up.

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELIADC86D9
Uploaded by :
Page 1 Preview
logapply services require memory the shared pool
Sell Your Old Documents & Earn Wallet Balance