Sort Segment (PD_PDSR)
- Organization of this page
Function
The Sort Segment (PD_PDSR) record stores performance data indicating the status of sort segments in a database at a specific point in time. PFM - Agent for Oracle creates one record for each sort segment. This is a multi-instance record.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
300 |
Y |
Collection Offset |
25 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PD_PDSR_TABLESPACE_NAME
-
PD_PDSR_SEGMENT_FILE
-
PD_PDSR_SEGMENT_BLOCK
Lifetime
From the start to the stop of an Oracle instance
Record size
-
Fixed part: 678 bytes
-
Variable part: 188 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Added Extents (ADDED_EXTENTS) |
Number of extents allocated |
-- |
double |
No |
All |
V$SORT_SEGMENT.ADDED_EXTENTS |
Current Users (CURRENT_USERS) |
Number of active users for the segment |
-- |
double |
No |
All |
V$SORT_SEGMENT.CURRENT_USERS |
Extent Hits (EXTENT_HITS) |
Number of times an unused extent was found in the pool |
-- |
double |
No |
All |
V$SORT_SEGMENT.EXTENT_HITS |
Extent Size (EXTENT_SIZE) |
Size of extent |
-- |
double |
No |
All |
V$SORT_SEGMENT.EXTENT_SIZE |
Free Blocks (FREE_BLOCKS) |
Blocks that are not allocated to any sort operation |
-- |
double |
No |
All |
V$SORT_SEGMENT.FREE_BLOCKS |
Free Extents (FREE_EXTENTS) |
Extents that are not allocated to any sort operation |
-- |
double |
No |
All |
V$SORT_SEGMENT.FREE_EXTENTS |
Free Requests (FREE_REQUESTS) |
Number of allocation release requests |
-- |
double |
No |
All |
V$SORT_SEGMENT.FREE_REQUESTS |
Freed Extents (FREED_EXTENTS) |
Number of extents whose allocation was released |
-- |
double |
No |
All |
V$SORT_SEGMENT.FREED_EXTENTS |
Max Blocks (MAX_BLOCKS) |
Maximum number of blocks used |
-- |
double |
No |
All |
V$SORT_SEGMENT.MAX_BLOCKS |
Max Size (MAX_SIZE) |
Maximum number of extents used |
-- |
double |
No |
All |
V$SORT_SEGMENT.MAX_SIZE |
Max Sort Blocks (MAX_SORT_BLOCKS) |
Maximum number of blocks used in individual sort operations |
-- |
double |
No |
All |
V$SORT_SEGMENT.MAX_SORT_BLOCKS |
Max Sort Size (MAX_SORT_SIZE) |
Maximum number of extents used in individual sort operations |
-- |
double |
No |
All |
V$SORT_SEGMENT.MAX_SORT_SIZE |
Max Used Blocks (MAX_USED_BLOCKS) |
Maximum number of blocks used in all sort operations |
-- |
double |
No |
All |
V$SORT_SEGMENT.MAX_USED_BLOCKS |
Max Used Size (MAX_USED_SIZE) |
Maximum number of extents used in all sort operations |
-- |
double |
No |
All |
V$SORT_SEGMENT.MAX_USED_SIZE |
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PDSR) |
-- |
string(4) |
No |
All |
Agent Collector |
Segment Block (SEGMENT_BLOCK) |
Block number of first extent |
-- |
double |
No |
All |
V$SORT_SEGMENT.SEGMENT_BLOCK |
Segment File (SEGMENT_FILE) |
File number of first extent |
-- |
ulong |
No |
All |
V$SORT_SEGMENT.SEGMENT_FILE |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Tablespace Name (TABLESPACE_NAME) |
Name of tablespace |
-- |
string(31) |
No |
All |
V$SORT_SEGMENT.TABLESPACE_NAME |
Total Blocks (TOTAL_BLOCKS) |
Number of blocks in the segment |
-- |
double |
No |
All |
V$SORT_SEGMENT.TOTAL_BLOCKS |
Total Extents (TOTAL_EXTENTS) |
Number of extents for the segment |
-- |
double |
No |
All |
V$SORT_SEGMENT.TOTAL_EXTENTS |
Used Blocks (USED_BLOCKS) |
Number of blocks allocated for active sort operation |
-- |
double |
No |
All |
V$SORT_SEGMENT.USED_BLOCKS |
Used Extents (USED_EXTENTS) |
Number of extents allocated for active sort operation |
-- |
double |
No |
All |
V$SORT_SEGMENT.USED_EXTENTS |