You want to allocate the memory structures in the shared pool so that you can begin collecting cache advice information at a later time. What is the correct setting for the DB_CACHE_ADVICE parameter?
A . OFF
B. READY
C . FALSE
E . ALLOCATE
Explanation:
Answer B: Setting DB_CACHE_ADVICE to READY allocates the memory structures in the shared pool to collect the statistics needed to populate the V$DB_CACHE_ADVICE view. The memory structures, and the view, are not populated with data until the DB_CACHE_ADVICE is set to ON, which signals the collection of buffer cache advice statistics. Setting the parameter to OFF stops collecting data and deallocates the shared pool memory structures.
No comments:
Post a Comment