Real-Time Database Operation Monitoring is actually a synonymous term of
SQL Monitoring for Enterprise Manager (either Cloud Control or Grid Control). Therefore, its features and purposes are all around monitoring the performance of SQL, such as the following operations:
- Expensive SQL statements.
- Long-running stored procedures.
- Batch jobs (either from scheduler or applications).
- ETL or Reporting.
- Data Pump.
Here are the tasks and purposes listed in official documentation when using SQL Monitoring.
- Tracking and reporting
- Monitoring execution progress
- Monitoring resource usage
- Tuning for response time
Any moment of the above, you can enable real-time database operation monitoring. But
STATISTICS_LEVEL initialization parameter must be either set to
TYPICAL (the default value) or
ALL.
For specific composite database operations, you may create a database operation by package
DBMS_SQL_MONITOR. For further information, you may refer to the following documentation:
Monitoring Real-Time Database Operations