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 ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.