English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (422)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 8i: Performance Tuning 

АвторSubject: Q66
written 18 October 2007 15:13   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
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

Current tread:
back to list

Q66 - Go to question 15:13 18.10.07

back to list
Up ^ gen. 0.059 Server date 07:25 08-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments