1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
  4. 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_NUMBERFoot 1

NUMBER

Version number when the statement was captured

SESSION_IDFoot 1

NUMBER

Unique session ID when the statement was captured

OPCODEFoot 1

NUMBER

NOT NULL

Operation code indicating the statement type

Footnote 1 This column is available starting with Oracle Database release 18c, version 18.1.