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: Q82
written 18 October 2007 15:13   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
The V$ROWCACHE view statistics is used to tune dictionary cache. You calculate the hit ratio using the formula : sum (GETS - GETMISSES) / sum (GETS) * 100. An ideal hit ratio for dictionary-cache activity is 99 percent or higher.
Incorrect Answers:

1: The V$ROWCACHE view is not used to tune the library cache. The V$LIBRARYCACHE view is used for this purpose.
3: With V$ROWCACHE you can tune only data dictionary cache, not entire shared pool cache.
4: This view is not used to determine the hit ratio for large objects such as PL/SQL packages.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 852-858. Chapter 18: Tuning Memory and Operating System Use

Current tread:
back to list

Q82 - Go to question 15:13 18.10.07

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