Ask a Question
Advertise on boostr.in
Question:To control fragmentation of a shared pool space, what is the best time to pin objects with the DBMS_SHARED_POOL package?
a. ¬†¬†¬†¬†¬†¬†¬†Immediately after instance startup
b. ¬†¬†¬†¬†¬†¬†¬†After an object has been used for the first time
c. ¬†¬†¬†¬†¬†¬†¬†When the V$LIBRARYCACHE view contains higher values in the RELOADS column than in the PINS column
d. ¬†¬†¬†¬†¬†¬†¬†When the sum of values in the SHARABLE_MEMORY column of the V$DB_OBJECT_CACHE view exceeds the value of the SHARED_POOL_SIZE initialization parameter
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please