Show TOC

Segments with Activated ParallelismLocate this document in the navigation structure

Definition

This sub-monitor in the SAP/Oracle Database Monitor shows the segments that have parallel degree activity based on the Oracle SQL script Segments_ParallelDegreeActive.txt given in SAP note 1438410 Information published on SAP site. This monitor displays the segments in the instance having parallel degree active. The data shown is based on the Oracle Automatic Workload Repository (AWR). For more information, see SAP note 1704439 Information published on SAP site.

You choose Start of the navigation path Performance Next navigation step Feature Monitoring Next navigation step Segments with Activated Parallelism End of the navigation path

Structure

Column

Description

Owner

Segment owner

Segment name

Segment name

Command

Alter command for the segment

Segment type

Segment type

Degree

Degree of parallelism

Instances

Number of instances