Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


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

Lifetime

From the start to the stop of an Oracle instance

Record size

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