Which three statements are true about using Real-Time D…

Which three statements are true about using Real-Time Database Operations?(Choose
three.)

Which three statements are true about using Real-Time Database Operations?(Choose
three.)

A.
TheSTATISTICS_LEVELinitialization parameter must be set toALLto enable automatic
SQL monitoring for all long-running queries.

B.
TheCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter must be set
toDIAGNOSTIC+TUNUNGto use Real-Time Database Operations.

C.
TheSTATISTICS_LEVELinitialization parameter can be set toTYPICALorALLto enable
Real-Time Database Operations.

D.
Real-Time Database Operations can be enabled only at the system level.

E.
Real-Time DatabaseOperations can be created by using
theDBMS_MONITORorDBMS_SESSIONpackages.

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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


vasya

vasya

imo B,C and F right.

Fonx

Fonx

BC OK

E maybe no I fera DBMS_SESSION can not manage RTD
F I fear the 5s story is the minimum duration to get dectected during un RTD (that’s why the MONITOR hints helps for testing purpose).

So i choose BCE but…