B free extents in a tablespace c blocks beyond the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ee lists used to identify? A. Blocks available for inserts. B. Free extents in a tablespace. C. Blocks beyond the high water mark in a segment. D. Segments belonging to a Parallel Server instance. Answer: A Explanation: Free lists are used to identify blocks available for inserts. Incorrect Answers: B: Free lists do not identify free extents in a tablespace. C: They also have nothing to do with blocks beyond the high water mark in a segment. D: Free lists do not relate with segments belonging to a Parallel Server instance. Actualtests.com - The Power of Knowing 1Z0-024 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 945-947. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 78: What should you confirm before changing the CURSOR_SPACE_FOR_TIME parameter in your initialization file to TRUE? A. The TIMED_STATISTICS parameter is set to TRUS B. The hit percentage in the buffer cache is at least 95% C. The OPEN_CURSORS parameter is set to at least twice the default value. D. The value in the RELOADS column of V$LIBRARYCACHE is consistently zero. Answer: D Explanation: The CURSOR_SPACE_FOR_TIME init.ora parameter influences library cache activity. When a user needs to parse and execute a SQL statement, Oracle may eliminate an existing SQL execution plan from the library cache to make room for the new one if CURSOR_SPACE_FOR_TIME is set to FALSE, the default. However, the problem here is that another process may need the execution plan to be eliminated to make room. If you set CURSOR_SPACE_FOR_TIME to TRUE, Oracle will not eliminate a parsed execution plan from the library cache until all open cursor user processes and applications using the execution plan have been closed. Library cache performance can be improved by setting CURSOR_SPACE_FOR_TIME to TRUE. However, you must be careful only to do so when your library-cache hit ratio is 100 %. If an execution miss occurs on your database when this parameter is set to TRUE and all execution plans in the library cache are associated with open cursors, your users will receive errors s...
View Full Document

Ask a homework question - tutors are online