|
Explanation: It's NEVER possible to achieve a zero value in the GETMISSES column of V$ROWCACHE view because at least some object definitions must be loaded from the data dictionary into the shared pool immediately after instance startup. Incorrect Answers:
1: The database buffer cache is not the same as the data dictionary cache. 2: Recursive SQL are stored in the library cache, not in the data dictionary cache. 4: An object can be pinned in the shared pool with the DBMS_SHARED_POOL. It does not matter whether this object have been in the shared pool or not. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-854. Chapter 18: Tuning Memory and Operating System Use
|