Karl Reitschuster's Tech Space

A really new step in real-time Oracle Performance Monitoring was the Database Control introduced with Oracle RDBMS 10.1; With Oracle 11.1 the concept was improved and more detailed metrics could be viewed via Database Control.

The Performance page has now 4 Tabs :

• Throughput
• I/O
• Parallel Execution
• Services

Choosing the Parallel Execution tab you get an overview in the scope of about 60 minutes about following parallel execution metrics :

• Number Sessions involved in Parallel Executions
• Number Sessions as Query Coordinators
• Number Session as Slaves
• Kind of Parallel Execution DDL/DML/Query
• Downgrade degree (serialized .. Not Downgraded) of parallel execution

This could result in following screen output :

The Image was captured during a text index creation with parallel degree 4. As you see not all Commands were DDL  but DML Commands due to the logic used behind a text index creation. And - not the complete index creation processed was done in parallel execution mode.

With Database Control 11.1 you are able to monitor your parallel executions effectively. A good step forward in my opinion.

Karl Reitschuster