10.83 V$SQL_SHARED_CURSOR_DIAG

V$SQL_SHARED_CURSOR_DIAG displays diagnostic information about child cursors that cannot be shared with existing child cursors.

You can find additional information about the cursors displayed in this view by querying the V$SQL_SHARED_CURSOR view. Join this view with V$SQL_SHARED_CURSOR on the SQL_ID and CHILD_NUMBER columns.

Column Datatype Description

SQL_ID

VARCHAR2(13)

SQL identifier

CHILD_NUMBER

NUMBER

Child number

FAILING_CRITERIA

VARCHAR2(4000)

Reason the child cursor failed to share, in JSON format

DIAG_DATA

CLOB

Diagnostic information, in JSON format

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.

See Also:

"V$SQL_SHARED_CURSOR"