Databases Reference
In-Depth Information
V$SORT_SEGMENT
This view displays information about every sort segment in a given instance.
Fields
The most relevant view fields are as follows:
F
TABLESPACE_NAME
: The name of the tablespace
F
CURRENT_USERS
: The active users of the segment
F
TOTAL_BLOCKS
: The total number of blocks in the segment
F
USED_BLOCKS
: The number of blocks in the segment allocated to active sorts
F
FREE_BLOCKS
: The number of blocks in the segment not allocated to any sort
F
MAX_BLOCKS
: The maximum number of blocks ever used
F
MAX_USED_BLOCKS
: The maximum number of blocks used by all sorts
F
MAX_SORT_BLOCKS
: The maximum number of blocks used by an individual sort
F
EXTENT_SIZE
: The extent size
F
TOTAL_EXTENTS
: The total number of extents in the segment
F
USED_EXTENTS
: The extents allocated to active sorts
F
FREE_EXTENTS
: The extents not allocated to any sort
F
EXTENT_HITS
: The number of times an unused extent was found in the pool
V$SQL
This view lists statistics on shared SQL areas.
Fields
The most relevant view fields are as follows:
F
SQL_ID
: The identifier of the parent cursor in the library cache
F
SQL_TEXT
: The first thousand characters of the SQL text
F
SQL_FULLTEXT
: The full text of the SQL statement
F
EXECUTIONS
: The number of executions that took place on this object since
it was brought into the library cache