1. Get Started with Performance Tuning
  2. Proactive Database Tuning
  3. Monitoring Real-Time Database Operations
  4. Monitoring Database Operations in Cloud Control
  5. Viewing SQL Execution Details for a PL/SQL Statement

Viewing SQL Execution Details for a PL/SQL Statement

This topic describes viewing the execution details for a PL/SQL statement.

To view execution details for a PL/SQL statement:

  1. Access the Database Home page.

    See "Accessing the Database Home Page" for more information.

  2. From the Performance menu, select Performance Hub and then SQL Monitoring.

    If the Database Login page appears, then log in as a user with administrator privileges. The Monitored SQL Execution page appears.

  3. Click the ID of a PL/SQL statement in the table.

    The Monitored SQL Execution Details page for the operation appears. In the Details section, the Activity subpage is selected by default.