Organizational Research By

Surprising Reserch Topic

boostr.in questions - 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
asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
19 views



Related Hot Questions



Government Jobs Opening


...