Oracle教程

Oracle 视图 DBA_APP_STATEMENTS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_APP_STATEMENTS是一个字典视图，用于查找可用的应用程序中的语句性能统计信息，包括SQL解析、计划步骤以及SQL执行计数、计时、I/O和内存分配信息等。这个视图最初是为配合Automatic Workload Repository (AWR)报表，但也可以用于任何时间检查逻辑IO和物理IO之间的性能差异，或者分析应用程序批量任务的时间、等待事件和其他性能指标。一般以APPLICATION_NAME来索引查询，我们可以使用SELECT语句查询，可以查询如调用环境、执行性能和饱和度等关键参数，然后识别高负载的模块或者步骤，来进一步完善资源分配性和性能调优。

官方英文解释

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


数据运维技术 » Oracle 视图 DBA_APP_STATEMENTS 官方解释，作用，如何使用详细说明
分享到：

相关推荐