1Z0-024 Oracle8i: Performance and Tuning Part 1
Oracle8i: Performance and Tuning Part 1 Get Full Version on: http://www.getfreedumps.com/ 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 Correct Answer: A Section: (none) Explanation Explanation/Reference: 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 remaind...