[Home] [Help] [Dependency Information]
Object Name: | V_$SEGSPACE_USAGE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TBS_ID | NUMBER | |||
RFNO | NUMBER | |||
BNO | NUMBER | |||
OBJD | NUMBER | |||
USED_SPACE | NUMBER | |||
USPSCNBASE | NUMBER | |||
USPSCNWRAP | NUMBER | |||
USPTIME | NUMBER | |||
CTIME | NUMBER | |||
TOTAL_ALLOC | NUMBER | |||
TOTAL_DEALLOC | NUMBER | |||
DELTA_ALLOC | NUMBER | |||
DELTA_DEALLOC | NUMBER | |||
DELTASCN_BASE | NUMBER | |||
DELTASCN_WRAP | NUMBER | |||
DELTAUPD_TIME | NUMBER | |||
DELTA_COUNT | NUMBER | |||
DF_COUNT | NUMBER | |||
FLAG | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TBS_ID
, RFNO
, BNO
, OBJD
, USED_SPACE
, USPSCNBASE
, USPSCNWRAP
, USPTIME
, CTIME
, TOTAL_ALLOC
, TOTAL_DEALLOC
, DELTA_ALLOC
, DELTA_DEALLOC
, DELTASCN_BASE
, DELTASCN_WRAP
, DELTAUPD_TIME
, DELTA_COUNT
, DF_COUNT
, FLAG
, CON_ID
FROM SYS.V_$SEGSPACE_USAGE;
|
|
|