DBA_APP_STATEMENTS

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
`VERSION_NUMBER`	`NUMBER`		Version number when the statement was captured
`SESSION_ID`	`NUMBER`		Unique session ID when the statement was captured
`OPCODE`	`NUMBER`	`NOT NULL`	Operation code indicating the statement type