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 |