Which three statements are true about using Real-Time Database Operations? (Choose three.)
Posted: Sun Jun 11, 2023 3:54 pm
Which three statements are true about using Real-Time Database Operations? (Choose three.)
A. The STATISTICS_LEVEL initialization parameter must be set to ALL to enable automatic SQL monitoring for all long-running queries.
B. The CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC+TUNUNG to use Real-Time Database Operations.
C. The STATISTICS_LEVEL initialization parameter can be set to TYPICAL or ALL to enable Real-Time Database Operations.
D. Real-Time Database Operations can be enabled only at the system level. E. Real-Time Database Operations can be created by using the DBMS_MONITOR or DBMS_SESSION packages. F. Database operation monitoring starts automatically when a database operation consumes at least five seconds of the CPU or I/O time in a single execution.
A. The STATISTICS_LEVEL initialization parameter must be set to ALL to enable automatic SQL monitoring for all long-running queries.
B. The CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC+TUNUNG to use Real-Time Database Operations.
C. The STATISTICS_LEVEL initialization parameter can be set to TYPICAL or ALL to enable Real-Time Database Operations.
D. Real-Time Database Operations can be enabled only at the system level. E. Real-Time Database Operations can be created by using the DBMS_MONITOR or DBMS_SESSION packages. F. Database operation monitoring starts automatically when a database operation consumes at least five seconds of the CPU or I/O time in a single execution.