1Z0-024 - Exam 1Z0-024 Title Performance Tuning Ver...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Exam : 1Z0-024 Titl e : Performance Tuning Ver : 08 . 03 .0 6
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1Z0-024 Actualtests.com - The Power of Knowing QUESTION 1: When performing a sort operation, you notice that there are a large number of sorts requiring I/O to the disk. Which parameter could be increased to allow more sorts to be performed in memory? A. SORT_AREA_SIZE B. LARGE_POOL_SIZE C. SORT_AREA_RETAINED_SIZE D. SORT_MULTIBLOCK_READ_COUNT Answer: A Explanation: To avoid a large number of sorts requiring I/O to the disk, SORT_AREA_SIZE parameter needs to be increased to perform more sorts in memory. SORT_AREA_SIZE specifies in bytes the maximum amount of memory Oracle will use for a sort. After the sort is complete, but before the rows are returned, Oracle releases all of the memory allocated for the sort, except the amount specified by the SORT_AREA_RETAINED_SIZE parameter. After the last row is returned, Oracle releases the remainder of the memory. Incorrect Answers: B: The LARGE_POOL_SIZE parameter is used to set the large pool. It's new area in the Oracle SGA that supports the Recovery Manager tool in recovering the Oracle database. C: SORT_AREA_RETAINED_SIZE specifies (in bytes) the maximum amount of the user global area (UGA) memory retained after a sort run completes. The retained size controls the size of the read buffer, which Oracle uses to maintain a portion of the sort in memory. This memory is released back to the UGA, not to the operating system, after the last row is fetched from the sort space. D: SORT_MULTIBLOCK_READ_COUNT specifies the number of database blocks to read each time a sort performs a read from a temporary segment. Temporary segments are used by a sort when the data does not fit in SORT_ARE_SIZE of memory. In these situations, sort writes out sections of data to temporary segments in the form of sorted runs. Once all the data has been partially sorted to these runs, sort merges the runs by reading pieces of them from the temporary segment into memory to produce the final sorted output. If SORT_AREA_SIZE is not large enough to merge all the runs at once, subsets of the runs are merged in a number of merge passes. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 855 Chapter 18: Tuning Memory and Operating System Use QUESTION 2: Which statement could require a sort?
Image of page 2