The GoldenGate dynamic performance views

Like all database components, Oracle provides a set of dynamic performance views (known as the v$ views) that allow the DBA to investigate and diagnose performance bottlenecks on the fly. The v$ views may be queried with minimal overhead during heavy processing to determine the following information:

View name

Description

V_$GOLDENGATE_CAPABILITIES

This lists the enabled capabilities of GoldenGate in the database, such as

DBLOGREADER,

TRIGGERSUPPRESSION,

TRANSIENTDUPLICATE, and

DDLTRIGGEROPTIMIZATION.

V_$GOLDENGATE_CAPTURE

This is similar to V_$STREAMS_CAPTURE that provides the integrated capture process information.

V_$GOLDENGATE_TABLE_STATS

This lists the collision, detection, and resolution (CRD) statistics for the integrated apply process.

V_$GOLDENGATE_TRANSACTION

This lists the in-flight transaction statistics.

V_$GOLDENGATE_MESSAGE_TRACKING

This is available in Oracle database future Release 12.2.

Note that each view has a GV_$ equivalent that supports RAC environments by including the database instance number (INST_ID) as its first column.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.71.142