[Home] [Help] [Dependency Information]
Object Name: | WRH$_SEG_STAT |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRH$_SEG_STAT_PK | NORMAL | UNIQUE |
DBID
SNAP_ID INSTANCE_NUMBER TS# OBJ# DATAOBJ# CON_DBID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
TS# | NUMBER | Yes | ||
OBJ# | NUMBER | Yes | ||
DATAOBJ# | NUMBER | Yes | ||
LOGICAL_READS_TOTAL | NUMBER | |||
LOGICAL_READS_DELTA | NUMBER | |||
BUFFER_BUSY_WAITS_TOTAL | NUMBER | |||
BUFFER_BUSY_WAITS_DELTA | NUMBER | |||
DB_BLOCK_CHANGES_TOTAL | NUMBER | |||
DB_BLOCK_CHANGES_DELTA | NUMBER | |||
PHYSICAL_READS_TOTAL | NUMBER | |||
PHYSICAL_READS_DELTA | NUMBER | |||
PHYSICAL_WRITES_TOTAL | NUMBER | |||
PHYSICAL_WRITES_DELTA | NUMBER | |||
PHYSICAL_READS_DIRECT_TOTAL | NUMBER | |||
PHYSICAL_READS_DIRECT_DELTA | NUMBER | |||
PHYSICAL_WRITES_DIRECT_TOTAL | NUMBER | |||
PHYSICAL_WRITES_DIRECT_DELTA | NUMBER | |||
ITL_WAITS_TOTAL | NUMBER | |||
ITL_WAITS_DELTA | NUMBER | |||
ROW_LOCK_WAITS_TOTAL | NUMBER | |||
ROW_LOCK_WAITS_DELTA | NUMBER | |||
GC_BUFFER_BUSY_TOTAL | NUMBER | |||
GC_BUFFER_BUSY_DELTA | NUMBER | |||
GC_CR_BLOCKS_RECEIVED_TOTAL | NUMBER | |||
GC_CR_BLOCKS_RECEIVED_DELTA | NUMBER | |||
GC_CU_BLOCKS_RECEIVED_TOTAL | NUMBER | |||
GC_CU_BLOCKS_RECEIVED_DELTA | NUMBER | |||
SPACE_USED_TOTAL | NUMBER | |||
SPACE_USED_DELTA | NUMBER | |||
SPACE_ALLOCATED_TOTAL | NUMBER | |||
SPACE_ALLOCATED_DELTA | NUMBER | |||
TABLE_SCANS_TOTAL | NUMBER | |||
TABLE_SCANS_DELTA | NUMBER | |||
CHAIN_ROW_EXCESS_TOTAL | NUMBER | |||
CHAIN_ROW_EXCESS_DELTA | NUMBER | |||
PHYSICAL_READ_REQUESTS_TOTAL | NUMBER | |||
PHYSICAL_READ_REQUESTS_DELTA | NUMBER | |||
PHYSICAL_WRITE_REQUESTS_TOTAL | NUMBER | |||
PHYSICAL_WRITE_REQUESTS_DELTA | NUMBER | |||
OPTIMIZED_PHYSICAL_READS_TOTAL | NUMBER | |||
OPTIMIZED_PHYSICAL_READS_DELTA | NUMBER | |||
CON_DBID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, TS#
, OBJ#
, DATAOBJ#
, LOGICAL_READS_TOTAL
, LOGICAL_READS_DELTA
, BUFFER_BUSY_WAITS_TOTAL
, BUFFER_BUSY_WAITS_DELTA
, DB_BLOCK_CHANGES_TOTAL
, DB_BLOCK_CHANGES_DELTA
, PHYSICAL_READS_TOTAL
, PHYSICAL_READS_DELTA
, PHYSICAL_WRITES_TOTAL
, PHYSICAL_WRITES_DELTA
, PHYSICAL_READS_DIRECT_TOTAL
, PHYSICAL_READS_DIRECT_DELTA
, PHYSICAL_WRITES_DIRECT_TOTAL
, PHYSICAL_WRITES_DIRECT_DELTA
, ITL_WAITS_TOTAL
, ITL_WAITS_DELTA
, ROW_LOCK_WAITS_TOTAL
, ROW_LOCK_WAITS_DELTA
, GC_BUFFER_BUSY_TOTAL
, GC_BUFFER_BUSY_DELTA
, GC_CR_BLOCKS_RECEIVED_TOTAL
, GC_CR_BLOCKS_RECEIVED_DELTA
, GC_CU_BLOCKS_RECEIVED_TOTAL
, GC_CU_BLOCKS_RECEIVED_DELTA
, SPACE_USED_TOTAL
, SPACE_USED_DELTA
, SPACE_ALLOCATED_TOTAL
, SPACE_ALLOCATED_DELTA
, TABLE_SCANS_TOTAL
, TABLE_SCANS_DELTA
, CHAIN_ROW_EXCESS_TOTAL
, CHAIN_ROW_EXCESS_DELTA
, PHYSICAL_READ_REQUESTS_TOTAL
, PHYSICAL_READ_REQUESTS_DELTA
, PHYSICAL_WRITE_REQUESTS_TOTAL
, PHYSICAL_WRITE_REQUESTS_DELTA
, OPTIMIZED_PHYSICAL_READS_TOTAL
, OPTIMIZED_PHYSICAL_READS_DELTA
, CON_DBID
FROM SYS.WRH$_SEG_STAT;
SYS.WRH$_SEG_STAT does not reference any database object
SYS.WRH$_SEG_STAT is referenced by following:
|
|
|