Couchman p 858 859 chapter 18 tuning memory and

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: racle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 858-859. Chapter 18: Tuning Memory and Operating System Use QUESTION 66: To provide more free lists for a number of your database segments, what is one of your options? A. Modify them with the INSERT_ _ FREELIST command. B. Drop and re-create them with the required FREELIST value. C. Change the default storage parameter of the tablespace(s) where they are stored. D. Modify the FREELIST_LIMIT parameter in your installation file and restart the instance. Answer: B Explanation: There is one option to change number of free lists for the database segment: drop and recreate the database segment with required FREELIST value. Oracle maintains list of blocks that have space available for data insertion for all tables, called FREELISTS. Incorrect Answers: A: This command will not change free list value for the database segment. C: Change of the default storage parameter for the tablespace will not modify free list parameter for the database segment. Actualtests.com - The Power of Knowing 1Z0-024 D: There is no FREELIST_LIMIT parameter in the installation file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 945-947. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 67: Which statement is true when connecting to the Oracle instance using the multithreaded server configuration? A. The User Global Area (UGA) may only contain sort areas. B. The User Global Area (UGA) may be accessible to dedicated servers. C. The User Global Area (UGA) components may reside in the large pool. D. The User Global Area (UGA) components may reside in the buffer cache. Answer: C Explanation: User Global Area (UGA) components may reside in the large pool in MTS configuration. Incorrect Answers: A: UGA stands for User Global Area, and it represents the amount of memory allocated in Oracle for a user session. So it may contain not only sort areas. B: In dedicated configuration session information, such as private SQL area, is stored in the memory allocated to the user process and...
View Full Document

Ask a homework question - tutors are online