Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
DBA_HIST_SESS_TIME_STATS
displays information about CPU and I/O time for interesting Streams sessions.
Column | Datatype | NULL | Description |
---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
SESSION_TYPE |
VARCHAR2(64) |
NOT NULL |
Type of session |
MIN_LOGON_TIME |
DATE |
Minimum logon time | |
SUM_CPU_TIME |
NUMBER |
Total CPU time | |
SUM_SYS_IO_WAIT |
NUMBER |
Total system I/O wait time | |
SUM_USER_IO_WAIT |
NUMBER |
Total user I/O wait time |