This preview shows page 1. Sign up to view the full content.
Unformatted text preview: efault tablespace.
C. Tablespace will rollback segments.
D. Same tablespace as the EMPLOYEE table.
Index EMP_INDX will be created in Scott's default tablespace by default in Oracle8i.
A: It's only possible if Scott has SYSTEM tablespace as default tablespace, but question does
not mention about this fact.
C: Index will be created in Scott's default tablespace, not in RBS tablespace.
D: Index will be created in Scott's default tablespace, not in the same tablespace as the
EMPLOYEE table uses.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 917-918.
Chapter 19: Tuning Disk utilization
Actualtests.com - The Power of Knowing 1Z0-024 QUESTION 81:
When setting multiple LRU latches in your initialization parameter file, what might you
also consider setting?
A. One buffer pool for each latch.
B. One DBWn process for each latch.
C. At one shared server for each latch.
D. At least two DBWn processes for each latch.
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.
A: S latch should have no less than 50 buffers in its set.
C: There is no direct relation between shared servers and latches in Oracle.
D: 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
What can you use the values in the GETS and GETMISSES...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09