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.
imo B,C and F right.
B,C,F
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…
BCF
F – https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL790