[Home] [Help] [Dependency Information]
Object Name: | V_$SORT_SEGMENT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLESPACE_NAME | VARCHAR2 | (30) | ||
SEGMENT_FILE | NUMBER | |||
SEGMENT_BLOCK | NUMBER | |||
EXTENT_SIZE | NUMBER | |||
CURRENT_USERS | NUMBER | |||
TOTAL_EXTENTS | NUMBER | |||
TOTAL_BLOCKS | NUMBER | |||
USED_EXTENTS | NUMBER | |||
USED_BLOCKS | NUMBER | |||
FREE_EXTENTS | NUMBER | |||
FREE_BLOCKS | NUMBER | |||
ADDED_EXTENTS | NUMBER | |||
EXTENT_HITS | NUMBER | |||
FREED_EXTENTS | NUMBER | |||
FREE_REQUESTS | NUMBER | |||
MAX_SIZE | NUMBER | |||
MAX_BLOCKS | NUMBER | |||
MAX_USED_SIZE | NUMBER | |||
MAX_USED_BLOCKS | NUMBER | |||
MAX_SORT_SIZE | NUMBER | |||
MAX_SORT_BLOCKS | NUMBER | |||
RELATIVE_FNO | NUMBER | |||
TS# | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TABLESPACE_NAME
, SEGMENT_FILE
, SEGMENT_BLOCK
, EXTENT_SIZE
, CURRENT_USERS
, TOTAL_EXTENTS
, TOTAL_BLOCKS
, USED_EXTENTS
, USED_BLOCKS
, FREE_EXTENTS
, FREE_BLOCKS
, ADDED_EXTENTS
, EXTENT_HITS
, FREED_EXTENTS
, FREE_REQUESTS
, MAX_SIZE
, MAX_BLOCKS
, MAX_USED_SIZE
, MAX_USED_BLOCKS
, MAX_SORT_SIZE
, MAX_SORT_BLOCKS
, RELATIVE_FNO
, TS#
, CON_ID
FROM SYS.V_$SORT_SEGMENT;
|
|
|