Note
This view is available starting with V4.4.1.
Purpose
The DBA_OB_TENANT_FLASHBACK_LOG_SCN view displays information about each log truncation operation in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| TIMESTAMP | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the log truncation operation was performed. The unit is microseconds. |
| SWITCHOVER_EPOCH | NUMBER(38) | NO | The SWITCHOVER_EPOCH value when the tenant role was switched to the NORMAL state. SWITCHOVER_EPOCH is a unique identifier for a switchover or failover operation. |
| OP_TYPE | VARCHAR2(64) | NO | The operation type. Valid values:
|
| FLASHBACK_LOG_SCN | NUMBER(38) | NO | The SCN to which the tenant logs are truncated. |
Sample query
Query information about each log truncation operation in the current tenant.
obclient(SYS@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_TENANT_FLASHBACK_LOG_SCN;
The query result is as follows:
+-----------+----------------------------+------------------+---------------------+---------------------+
| TENANT_ID | TIMESTAMP | SWITCHOVER_EPOCH | OP_TYPE | FLASHBACK_LOG_SCN |
+-----------+----------------------------+------------------+---------------------+---------------------+
| 1006 | 21-MAY-25 16:48:53.583749 | 1747817333380437 | FAILOVER TO PRIMARY | 1747817331313513000 |
+-----------+----------------------------+------------------+---------------------+---------------------+
1 row in set