Segment Detail (PD_PDSM)
- Organization of this page
Function
The Segment Detail (PD_PDSM) record stores performance data indicating the status of database segments at a specific point in time. PFM - Agent for Oracle creates one record for each segment. This is a multi-instance record.
In an environment where many (more than hundreds of thousands of) segments exist, the following might occur:
-
The size of the Store database increases.
-
Data collection requires a long time.
If you do not need performance data for each segment, consider using alternative records. For example, you can use the Tablespace (PD_PDTS) record to monitor the size of tablespaces and check the number of segments.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
600 |
Y |
|
Collection Offset |
120 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
Yes |
N |
ODBC key fields
-
PD_PDSM_SEGMENT_NAME
-
PD_PDSM_TABLESPACE_NAME
Lifetime
From the creation to the deletion of a segment
Record size
-
Fixed part: 678 bytes
-
Variable part: 231 bytes
Fields
|
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
|---|---|---|---|---|---|---|
|
Blocks (BLOCKS) |
Segment size in Oracle blocks |
-- |
ulong |
No |
All |
|
|
Bytes (BYTES) |
Segment size in bytes |
-- |
double |
No |
All |
|
|
Extents (EXTENTS) |
Number of extents allocated to this segment |
-- |
ulong |
No |
All |
|
|
Free list Groups (FREELIST_GROUPS) |
Number of free list groups allocated to the segment. Performance data about the locally managed temporary tablespace is not collected. |
-- |
ulong |
No |
All |
DBA_SEGMENTS.FREELIST_GROUPS |
|
Free lists (FREELISTS) |
Number of process free lists allocated to the segment. Performance data about the locally managed temporary tablespace is not collected. |
-- |
ulong |
No |
All |
DBA_SEGMENTS.FREELISTS |
|
Header Block (HEADER_BLOCK) |
Block ID including the segment header. Performance data about the locally managed temporary tablespace is not collected. |
-- |
ulong |
No |
All |
DBA_SEGMENTS.HEADER_BLOCK |
|
Header File (HEADER_FILE) |
File ID including the segment header. Performance data about the locally managed temporary tablespace is not collected. |
-- |
ushort |
No |
All |
DBA_SEGMENTS.HEADER_FILE |
|
Increase % (PCT_INCREASE) |
The percentage increase in size of the extent due to the next extent allocation. Performance data about the locally managed temporary tablespace is not collected. |
-- |
short |
No |
All |
DBA_SEGMENTS.PCT_INCREASE |
|
Initial Extent (INITIAL_EXTENT) |
Size of the initial extent for the segment in bytes. Performance data about the locally managed temporary tablespace is not collected. |
-- |
double |
No |
All |
DBA_SEGMENTS.INITIAL_EXTENT |
|
Max Extents (MAX_EXTENTS) |
Maximum number of extents permitted for the segment. Performance data about the locally managed temporary tablespace is not collected. |
-- |
ulong |
No |
All |
DBA_SEGMENTS.MAX_EXTENTS |
|
Max Extents % (PERCENT_MAX_EXTENTS) |
Ratio (as a percent) of the currently allocated extents to the maximum number of extents permitted for the segment. Performance data about the locally managed temporary tablespace is not collected. |
-- |
double |
No |
All |
(DBA_SEGMENTS.EXTENTS / DBA_SEGMENTS.MAX_EXTENTS) * 100 |
|
Min Extents (MIN_EXTENTS) |
Minimum number of extents permitted for the segment |
-- |
ulong |
No |
All |
DBA_SEGMENTS.MIN_EXTENTS |
|
Next Alloc Fails (NEXT_ALLOC_FAILS) |
Correct values cannot be collected for this field. Failure of the next extent allocation. If it fails, the value of this field is 1. |
-- |
short |
No |
All |
DBA_SEGMENTS.NEXT_EXTENT > MAX(FET$.LENGTH) * DB_BLOCK_SIZE |
|
Next Extent (NEXT_EXTENT) |
Size of the next extent for the segment in bytes |
-- |
double |
No |
All |
DBA_SEGMENTS.NEXT_EXTENT |
|
Overextended (OVEREXTENDED) |
Correct values cannot be collected for this field. If the number of extents is greater than the specified value (initial value is 5), the value of this field is 1; Otherwise, the value of this field is 0. |
-- |
short |
No |
All |
|
|
Owner (OWNER) |
Segment owner's user name. Performance data about the locally managed temporary tablespace is not collected. |
-- |
string(30) |
No |
All |
DBA_SEGMENTS.OWNER |
|
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 PDSM) |
-- |
string(4) |
No |
All |
Agent Collector |
|
Segment Name (SEGMENT_NAME) |
Segment name. Performance data about the locally managed temporary tablespace is not collected. |
-- |
string(81) |
No |
All |
DBA_SEGMENTS.SEGMENT_NAME |
|
Segment Type (SEGMENT_TYPE) |
Segment type. Valid values are CACHE, CLUSTER, DEFERRED ROLLBACK, INDEX, ROLLBACK, TABLE, and TEMPORARY. Performance data about the locally managed temporary tablespace is not collected. |
-- |
string(18) |
No |
All |
DBA_SEGMENTS.SEGMENT_TYPE |
|
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 that contains the segment |
-- |
string(30) |
No |
All |
DBA_SEGMENTS.TABLESPACE_NAME |