IO - Table Spaces
Purpose
Histograms and Summaries (Gauges)
(link TBD)
Metrics Shown in Grid
Tablespace Name
THe name is prepended with '!' if the tablespace state is not "NORMAL". For example "OFFLINE" or "ROLLFORWARD_IN_PROGRESS".
Source: mon_get_tablespace.tbsp_name
Logical Reads/s
Source: mon_get_tablespace
Physical Reads/s
Source: mon_get_tablespace
Hit Ratio%
Source: mon_get_tablespace
Async Reads%
Source: mon_get_tablespace
Pages Aread
Source: mon_get_tablespace
Writes/s
Source: mon_get_tablespace
Async Reads/s
Source: mon_get_tablespace
Async Writes/s
Source: mon_get_tablespace
Direct Writes/s
Source: mon_get_tablespace
Data Writes/s
Source: mon_get_tablespace
Index Writes/s
Source: mon_get_tablespace
Avg_Reads Dir_Reqs
Source: mon_get_tablespace
Avg RdTime(ms)
Source: mon_get_tablespace
Avg WrTime(ms)
Source: mon_get_tablespace
Tbsp Type
Possible values are:
- Regular
- Large
- System temporary
- User temporary
Source: mon_get_tablespace.tbsp_content_type
# of DBP
Source: mon_get_tablespace
Avg PrefSize
Source: mon_get_tablespace
I/O Skew
Tbspace Status
For example, "NORMAL", "BACKUP_PENDING", "OFFLINE". Click tbsp_state for the full list of possible values.
Source: mon_get_tablespace.tbsp_state
Tbspace Type
Source: mon_get_tablespace
FSC On
Source: mon_get_tablespace
File Closed/s
Source: mon_get_tablespace
Victim Buffers/s
Source: mon_get_tablespace
Unread PrefPages/s
Source: mon_get_tablespace
XDA l_reads/s
Source: mon_get_tablespace
XDA p_reads/s
Source: mon_get_tablespace
XDA l_writes/s
Source: mon_get_tablespace
Prefetch Size
Source: mon_get_tablespace
IO/s
Source: mon_get_tablespace
Default Sort Column
Tablespace Name: Ascending
Navigation
Keyboard navigation: VIt
Dedicated shortcut key: alt-t