This preview shows page 1. Sign up to view the full content.
Unformatted text preview: efresh optimizer statistics.
C. Create multiple small rollback segments as opposed to a few big ones.
D. Create indexes on all columns that are regularly used in query predicates.
E. Set up appropriate default storage parameter values for dynamic (implicit) space allocation.
Answer: B, C,
There are several design paradoxes inherent in OLTP systems. First, OLTP systems need to be
designed to facilitate fast data entry without sacrificing accuracy. Any mechanism that checks
the data being entered will cause some performance degradation. Data change is the primary
function of an OLTP system. The designers and DBAs of such systems must work with users to
create an effective trade-off between viewing data quickly and making data changes quickly.
Because of quick data changes you need to analyze your tables regularly to keep optimizer
statistics up to date. Because of high volume of user connections it's reasonable to create
multiple small rollback segments as opposed to a few big ones.
A: Using bind variables rather than literals in your SQL code will cause performance
degradation because SQL statements will be parsed again.
D: Iindexes on ALL columns will decrease performance also, because of high volume of insert,
delete and update requires indexes rebuilding constantly.
E: Setting up default storage parameter values for dynamic space allocation will cause
Actualtests.com - The Power of Knowing 1Z0-024
performance degradation, because these parameters need to be set based on database activity,
insert and updates.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 793-795
Chapter 17: Tuning Database Applications
Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is
not specified for a user?
SYSTEM tablespace will be used as the temporary tablespace if TEMPORARY TABLESPACE
is not specified for a user.
A: There is no TEMP table...
View Full Document
- Fall '09