 |
|
|
dba_hist_sessmetric_history The dba_hist_sessmetric_history view collects history information for important session related metrics such as:
SQL> select metric_name from dba_hist_metric_name where group_name like 'Session Metrics%';
METRIC_NAME -------------------------------------- Blocked User Session Count Logical Reads Ratio (Sess/Sys) % Physical Reads Ratio (Sess/Sys) % Total Parse Count (Session) Hard Parse Count (Session) PGA Memory (Session) Physical Reads (Session) CPU Time (Session) User Transaction Count (Session)
The dba_hist_sessmetric_history view can be queried to find additional metric details about particular sessions of interest.
SQL> desc DBA_HIST_SESSMETRIC_HISTORY
Name Null? Type ----------------------------------------- -------- ---------- SNAP_ID NOT NULL NUMBER DBID NOT NULL NUMBER INSTANCE_NUMBER NOT NULL NUMBER BEGIN_TIME NOT NULL DATE END_TIME NOT NULL DATE SESSID NOT NULL NUMBER SERIAL# NOT NULL NUMBER INTSIZE NOT NULL NUMBER GROUP_ID NOT NULL NUMBER METRIC_ID NOT NULL NUMBER METRIC_NAME NOT NULL VARCHAR2(64) VALUE NOT NULL NUMBER METRIC_UNIT NOT NULL VARCHAR2(64)
This view contains a metric_unit column that helps identify the units of measure for every metric.
|
|
|
