1z0-447 Oracle GoldenGate 12c Implementation Essentials Questions and Answers

if The Enterprise Manager Agent is running

if the JAgent has been enabled in the GoldenGate Manager

if the agent type is set to OEM in JAgent properties

if the Oracle Wallet has been created for the JAgent

Run thechkpt_db_extracttrail.sqlscript.

Run thechkpt_db_create.sqlscript.

Use theADD Extract Trailcommand.

Use theINFO REPLICATcommand with theSHOWCHoption.

Use theADD CHECKPOINTTABLEcommand.

Manager

Replicat

Extract

Extract and Replicat

It is caused byTHREAD and THREADRANGEbeing used with wildcard MAP statements.

It is caused by the thread with the highest thread ID applying barrier transactions.

It is caused by the use of theMAXTRANSOPSparameter.

It is caused by barrier transactions in a Coordinated Replicat.

When using a data pump to distribute all of the trail data "as is" to a remote system.

When Extract is processing database transaction logs where you have a remote database connection.

For a SPECIALRUN one-time processing task that is doing an initial load.

When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

Data Pump is a separate process.

Data Pump can be used to pump trail records to multiple locations.

Data Pump has distance limitations.

Data Pump uses TCP/IP to route the trail records.

the number of concurrent users

disk space

system memory

the number of compound keys on the source tables