Performance

In the Database Alert Monitor user menu, you can find, among other things, a display of the free database sessions for user tasks, the database trace status, the status of the log queues, and information on the Optimizer statistics.

Prerequisites

Prerequisites
Alert monitoring must be activated.

Procedure

1. Start the Database Alert Monitor.

2. Choose <Name of the database connection> ® Performance.

Result

The system displays the following:

·        Caches

·        User Tasks

·        Monitor

·        Optimizer Statistics