Unformatted text preview: table scans to retrieve all needed blocks.
A: 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).
B: Small block sizes will not result in more block contention.
E: 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
Sometimes the LGWR process must wait because DBWn has not compressed
checkpointing a file. How do you identify this situation?
Actualtests.com - The Power of Knowing 1Z0-024 A. Check the V$SESSION_WAIT view for the 'log buffer space' event.
B. Check the alert.log file for the message "CHECKPOINT NOT COMPLETE"
C. Check the 'redo buffer allocation retries' statistic in the V$SYSSTAT view
D. Check the 'log file switch (checkpoint complete)' event in the V$SYSTEM_EVENT view
To identify this situation you need to check alert log file, it will be message: "CHECKPOINT
A: V$SESSION_WAIT view is used to show list the resources or events for which active
sessions are waiting, where WAIT_TIME = 0 for current events.
C: V$SYSSTAT view contains general statistics for the instance by name.
D: V$SYSTEM_EVENT view is used to show total waits for an event.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 902.
Chapter 19: Tuning Disk utilization
You want to reduce the amount of redo generated for your database. What are three ways
to achieve this goal? (Choose three)
A. Use NOLOGGING mode in SQL statements.
B. Use direct load UPDATE to NOLOGGING
C. Use direct path loading without archiving.
D. Use direct path loading with archiving using NOLOGGING mode.
E. Start your instance with the NOLOGGING initialization parameter.
Answer: A, C, D
To avoid redo information generating you can use NOLOGGING mode in SQL statements, use
direct path loading without archiving...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide