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 |
|---|---|
|
|
This lists the enabled capabilities of GoldenGate in the database, such as
|
|
|
This is similar to |
|
|
This lists the collision, detection, and resolution (CRD) statistics for the integrated apply process. |
|
|
This lists the in-flight transaction statistics. |
|
|
This is available in Oracle database future Release 12.2... |