Incorrect answers a random access to large objects

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: table scans to retrieve all needed blocks. Incorrect Answers: 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 QUESTION 74: 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 Answer: B Explanation: To identify this situation you need to check alert log file, it will be message: "CHECKPOINT NOT COMPLETE". Incorrect Answers: 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 QUESTION 75: 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 mode. 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 Explanation: To avoid redo information generating you can use NOLOGGING mode in SQL statements, use direct path loading without archiving...
View Full Document

Ask a homework question - tutors are online