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: Q81
written 18 October 2007 15:13   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
It's reasonable to consider to set one DBWn process for each latch when setting multiple LRU latches in your initialization parameter file. The LRU (least-recently-used) latch controls the server process's access to write new buffers into the buffer cache. Oracle automatically sets the number of LRU latches to be one-half the number of CPUs on the system. When your host machine has only one processor, one LRU latch is sufficient. Contention for the LRU latch can impede database performance when a large number of CPUs are available on the host system, when only one DBW0 process is available on the database, or when the load between multiple DBWn processes is unequally distributed.
Incorrect Answers:

1: S latch should have no less than 50 buffers in its set.
3: There is no direct relation between shared servers and latches in Oracle.
4: Each latch requires at least one, not two, DBWn process.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 855-856. Chapter 20: Tuning Other Areas of the Oracle Database

Current tread:
back to list

Q81 - Go to question 15:13 18.10.07

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