|
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:
1: This command will not change free list value for the database segment. 3: Change of the default storage parameter for the table space will not modify free list parameter for the database segment. 4: 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
|