This preview shows page 1. Sign up to view the full content.
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.
Free lists are used to identify blocks available for inserts.
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
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.
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
- Fall '09