4.66 DBA_APP_STATEMENTS

DBA_APP_STATEMENTS describes all statements from all the applications in the Application Container.

Column	Datatype	NULL	Description
ORIGIN_CON_ID	NUMBER		The ID of the container where the data originates. Possible values include: 0: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n=1 if the row originates in root)
STATEMENT_ID	NUMBER		Statement ID
CAPTURE_TIME	DATE	NOT NULL	Time of capture of the application statement
APP_STATEMENT	CLOB		Application statement
APP_NAME	VARCHAR2(128)		Name of the application whose statement was captured
APP_STATUS	VARCHAR2(12)		Status of the application when the statement was captured
PATCH_NUMBER	NUMBER		Patch number of patch installation when the statement was captured

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).