1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$SCHEDULER_IN_MEMORY_TRACE to V$ZONEMAP_USAGE_STATS
  4. V$SHARD_LCR_LOGS

10.48 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

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 23ai.