V$CLIENT_HA_READINESS

V$CLIENT_HA_READINESS displays information about high availability readiness for database clients.

Column Datatype Description
SID NUMBER Session identifier (can be used to join this view with V$SESSION)
SERIAL# NUMBER Session serial number. Used to uniquely identify a session’s objects.
CLIENT_VERSION VARCHAR2(40) Client library version number
CLIENT_DRIVER VARCHAR2(30)

Client driver name

For pooled connections, the value of this column is null.
NET_SERVER VARCHAR2(16)

Server type, when in use:

  • DEDICATED

  • POOLED

  • SHARED

  • NONE

For idle shared server sessions, the value of this column is NONE.

CONNECTION_POOL VARCHAR2(32) Name of the connection pool
CONNECTION_POOL_ID VARCHAR2(64) Connection pool ID
SERVICE_NAME VARCHAR2(64) Service name
PARENT_SERVICE_NAME VARCHAR2(64) Parent service name
COLOCATION_TAG VARCHAR2(64) Colocation TAG received on the connection string
CLIENT_CONNECTION_STRING VARCHAR2(4000) Connection string used to establish the connection
SESSION_CONNECT_TIME NUMBER Connect time for the session in 10s of milliseconds
FAN_READINESS VARCHAR2(32)

Fast Application Notification (FAN) readiness:

  • FAILED TO SUBSCRIBE

  • READY

  • NOT APPLICABLE

  • NOT CONFIGURED
FAN_METHOD VARCHAR2(32)

FAN method

  • AUTO

  • MANUAL
FAN_ERROR NUMBER If an error occurred when subscribing to FAN, the error number. Otherwise, null.
INBAND_NOTIFICATION VARCHAR2(32)

Inband notification received from client:

  • MANUALLY DISABLED

  • READY

Null if no such notification was received.
COMMIT_OUTCOME_ACTUAL VARCHAR2(16)

Indicates the actual commit outcome configuration for the session:

  • OFF - Commit outcome is disabled

  • STANDARD - Standard commit outcome is enabled

  • FASTPATH - Commit outcome with FastPath is enabled

FAILOVER_TYPE_ACTUAL VARCHAR2(16)

Indicates the actual failover type configured for the session:

  • NONE - Failover is not configured

  • TRANSACTION - Transaction failover is enabled

  • SESSION - Automatic reconnect, no transaction failover

  • SELECT - Automatic reconnect, query re-execution

  • AUTO - Automatic failover mode is enabled

FAILOVER_RESTORE_ACTUAL VARCHAR2(16)

Indicates the actual failover restore level configured for the session:

  • NONE - No session state restoration

  • LEVEL1 - Basic session state restoration

  • LEVEL2 - Extended session state restoration

  • AUTO - Extended session state restoration

This setting determines the amount of session state restored after failover.
RESET_STATE_ACTUAL VARCHAR2(16)

Indicates the actual session reset state level configured for the session:

  • NONE - The session is not cleaned at the end of the request.

  • LEVEL1 - The session states, which cannot be restored, are reset when a session is returned to the connection pool that uses request boundaries.

  • LOGIN - The session states are returned to the login state when a session is returned to the connection pool that uses request boundaries.
TDE_ENABLED NUMBER Indicates whether encryption of dictionary credentials is enforced (1) or not (0)
TIME_CURRENT_REQUEST_STARTED TIMESTAMP(6) WITH TIME ZONE Time of last received drain point
CLIENT_REQUESTS_COMPLETED_COUNT NUMBER Number of completed client requests
CLIENT_REQUESTS_ELAPSED_TIME NUMBER Cumulative time spent in client requests (in microseconds)
PERCENT_PROTECTED_CALLS_IN_REQS NUMBER Percentage of user calls protected by Application Continuity
PERCENT_PROTECTED_TIME_IN_REQS NUMBER Percentage of time spent in requests by Application Continuity protecting user calls
HA_LEVEL1_READINESS NUMBER Reserved for internal use
CONNECTING_READINESS NUMBER Reserved for internal use
HA_LEVEL2_DRAIN_BOUNDED_READINESS NUMBER Reserved for internal use
HA_LEVEL2_DRAIN_UNBOUNDED_READINESS NUMBER Reserved for internal use
HA_LEVEL3_FAILOVER_READINESS NUMBER Reserved for internal use
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 AI Database 26ai, Release Update 23.26.3.