PrepAway - Latest Free Exam Questions & Answers

Which command must be executed to enable the table func…

When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics
like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity
occurring in the database. Which command must be executed to enable the table function to return actual
data?

PrepAway - Latest Free Exam Questions & Answers

A.
UPDATE DB CFG USING MON_OBJ_METRICS BASE

B.
UPDATE DB CFG USING MON_ACT_METRICS BASE

C.
UPDATE DBM CFG USING DFT_MON_BUFPOOL ON

D.
UPDATE MONITOR SWITCHES USING BUFFERPOOL ON


Leave a Reply