Sort Segment Interval (PI_PISR)
- Organization of this page
Function
The Sort Segment Interval (PI_PISR) record stores performance data, taken at specific intervals, about sort segments in a database. 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 |
15 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PI_PISR_SEGMENT_FILE
-
PI_PISR_SEGMENT_BLOCK
Lifetime
From the start to the stop of an Oracle instance
Record size
-
Fixed part: 678 bytes
-
Variable part: 392 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Added Extents (ADDED_EXTENTS) |
Number of extents allocated#2 |
AVG |
double |
Yes |
All |
V$SORT_SEGMENT.ADDED_EXTENTS |
Current Users (CURRENT_USERS) |
Number of active users for the segment#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.CURRENT_USERS |
Extent Hits (EXTENT_HITS) |
Number of times an unused extent was found in the pool#2 |
AVG |
double |
Yes |
All |
V$SORT_SEGMENT.EXTENT_HITS |
Extent Size (EXTENT_SIZE) |
Size of extent#1 |
COPY |
double |
No |
All |
V$SORT_SEGMENT.EXTENT_SIZE |
Free Blocks (FREE_BLOCKS) |
Blocks that are not allocated to any sort operation#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.FREE_BLOCKS |
Free Extents (FREE_EXTENTS) |
Extents that are not allocated to any sort operation#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.FREE_EXTENTS |
Free Requests (FREE_REQUESTS) |
Number of allocation release requests#2 |
AVG |
double |
Yes |
All |
V$SORT_SEGMENT.FREE_REQUESTS |
Freed Extents (FREED_EXTENTS) |
Number of extents whose allocation was released#2 |
AVG |
double |
Yes |
All |
V$SORT_SEGMENT.FREED_EXTENTS |
Max Blocks (MAX_BLOCKS) |
Maximum number of blocks used#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.MAX_BLOCKS |
Max Size (MAX_SIZE) |
Maximum number of extents used#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.MAX_SIZE |
Max Sort Blocks (MAX_SORT_BLOCKS) |
Maximum number of blocks used in individual sort operations#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.MAX_SORT_BLOCKS |
Max Sort Size (MAX_SORT_SIZE) |
Maximum number of extents used in individual sort operations#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.MAX_SORT_SIZE |
Max Used Blocks (MAX_USED_BLOCKS) |
Maximum number of blocks used in all sort operations#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.MAX_USED_BLOCKS |
Max Used Size (MAX_USED_SIZE) |
Maximum number of extents used in all sort operations#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.MAX_USED_SIZE |
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PISR)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
Segment Block (SEGMENT_BLOCK) |
Block number of first extent#1 |
COPY |
double |
No |
All |
V$SORT_SEGMENT.SEGMENT_BLOCK |
Segment File (SEGMENT_FILE) |
File number of first extent#1 |
COPY |
ulong |
No |
All |
V$SORT_SEGMENT.SEGMENT_FILE |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Tablespace Name (TABLESPACE_NAME) |
Name of tablespace#1 |
COPY |
string(31) |
No |
All |
V$SORT_SEGMENT.TABLESPACE_NAME |
Total Blocks (TOTAL_BLOCKS) |
Number of blocks in the segment#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.TOTAL_BLOCKS |
Total Extents (TOTAL_EXTENTS) |
Number of extents for the segment#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.TOTAL_EXTENTS |
Used Blocks (USED_BLOCKS) |
Number of blocks allocated for active sort operation#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.USED_BLOCKS |
Used Extents (USED_EXTENTS) |
Number of extents allocated for active sort operation#2 |
AVG |
double |
No |
All |
V$SORT_SEGMENT.USED_EXTENTS |