oracle dba_hist_sql,【DBA】DBA_HIST_SQLSTAT视图用途

SNAP_ID

NUMBER

NOT NULL

快照的ID

DBID

NUMBER

NOT NULL

数据库ID

INSTANCE_NUMBER

NUMBER

NOT NULL

实例ID

SQL_ID

VARCHAR2(13)

NOT NULL

SQL identifier of the parent cursor in the library cache

PLAN_HASH_VALUE

NUMBER

NOT NULL

Numerical representation of the SQL plan for the cursor. Comparing one

PLAN_HASH_VALUE to another easily identifies whether or not two plans are the same (rather than comparing the two plans line by line).--SQL执行计划的hash值

OPTIMIZER_COST

NUMBER

Cost of the query given by the optimizer

OPTIMIZER_MODE

VARCHAR2(10)

Mode under which the SQL statement is executed

OPTIMIZER_ENV_HASH_VALUE

NUMBER

Hash Value for the optimizer environment

SHARABLE_MEM

NUMBER

Amount of shared memory used by the child cursor (in bytes)

LOADED_VERSIONS

NUMBER

Indicates whether the context heap is loaded (

1) or not (

0)

VERSION_COUNT

NUMBER

Number of children associated with the cursor

MODULE

VARCHAR2(64)

Contains the name of the module that was executing at the time that the SQL statement was first parsed, which is set by calling

DBMS_APPLICATION_INFO.SET_MODULE

ACTION

VARCHAR2(64)

Contains the name of the action that was executing at the time that the SQL statement was first parsed, which is set by calling

DBMS_APPLICATION_INFO.SET_ACTION

SQL_PROFILE

VARCHAR2(64)

Name of the applied SQL Profile

FORCE_MATCHING_SIGNATURE

NUMBER

The signature used when the

CURSOR_SHARINGparameter is set to

FORCE

PARSING_SCHEMA_ID

NUMBER

Schema ID that was used to originally build the child cursor

PARSING_SCHEMA_NAME

VARCHAR2(128)

Schema name that was used to originally build the child cursor

PARSING_USER_ID

NUMBER

User ID that was used to originally build the child cursor

FETCHES_TOTAL

NUMBER

Cumulative number of fetches assoc