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: Q73
written 18 October 2007 15:13   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
The key feature of a decision support system is fast sequential access to large amounts of data, so DSS environment prefer a large database block size. Also remember that you can reduce the number of block visits by packing rows as closely as possible into blocks, so Oracle will need less table scans to retrieve all needed blocks.
Incorrect Answers:

1: Random access to large objects will work better with small block size. It happens often in OLTP systems. For full scans large block size is more preferable (DSS systems).
2: Small block sizes will not result in more block contention.
5: So change the database block size, you must rebuild database. Shutdown the instance and STARTUP with RESETLOGS option will not change database block size.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 793-796. Chapter 17: Tuning Database Applications

Current tread:
back to list

Q73 - Go to question 15:13 18.10.07

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