V$SHARD_LCR_LOGS
V$SHARD_LCR_LOGS displays information about LCR logs.
| Column | Datatype | Description |
|---|---|---|
INST_ID |
NUMBER |
Instance ID |
RU_ID |
NUMBER |
Replication unit (RU) ID |
NAME |
VARCHAR2(257) |
Name and path of the log file |
SIZE_GB |
NUMBER |
Size of the log file (in gigabytes) |
ROTD_IDX |
NUMBER |
Rotated index |
CURR_FILE |
VARCHAR2(1) |
Indicates whether the file is current (Y) or not (N) |
STIDX_HIGH |
NUMBER |
High 4 bytes of the starting log index in the log file |
STIDX_LOW |
NUMBER |
Low 4 bytes of the starting log index in the log file |
ENDIDX_HIGH |
NUMBER |
High 4 bytes of the ending log index in the log file |
ENDIDX_LOW |
NUMBER |
Low 4 bytes of the ending logindex in the log file |
START_SEC |
NUMBER |
Time when this log file was first written to, measured in seconds from the epoch |
MODIFY_SECFoot 1 |
NUMBER |
Time when this log file was most recently written to, measured in seconds from the epoch |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.2.
Note: This view is available starting with Oracle AI Database 26ai.