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 AI Database 26ai.

See Also: “V$SQL_SHARED_CURSOR”