Note
This view is available starting with V4.2.1.
Purpose
This view displays the configuration information related to WR.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID.
|
| SNAP_INTERVAL | VARCHAR2(64) | NO | The interval between snapshots, in the DD HH:mm:SS format for easy reading. |
| RETENTION | VARCHAR2(64) | NO | The retention period for each snapshot, in the DD HH:mm:SS format for easy reading. |
| TOPNSQL | NUMBER(38) | NO | The SQL statements to be stored in the topN. |
Sample query
Query WR-related configuration information.
obclient [SYS]> SELECT * FROM SYS.DBA_WR_CONTROL WHERE ROWNUM <= 1\G