D it is probably at its optimal setting because the

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: pass executions. D. It is probably at its optimal setting because the ratio of one pass to multipass work area executions is below 0.10 (ten percent). Answer: B Explanation: If the PGA_AGGREGATE_TARGET initialization parameter is set too low there will be more multipass work area executions than one pass executions. Incorrect Answers A: These statistics are related to the PGA_AGGREGATE_TARGET parameter. C: If you set the PGA_AGGREGATE_TARGET initialization parameter is set too high there will be more one pass work area executions than multipass executions. D: It's not optimal setting because there are many more multipass work area executions Actualtests.com - The Power of Knowing 1Z0-030 than one pass executions. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 176-182 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 19-25 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 27: Which two are true regarding the Automatic Undo Management feature? (Choose two). A. PMON is responsible for shrinking undo segments as needed. B. SMON is responsible for shrinking undo segments as needed. C. To use this feature, you must create undo segments into an undo tablespace. D. Oracle9i automatically creates a fixed number of undo segments per undo tablespace. E. In a Real Application Clusters environment, you must create one undo tablespace per opened instance. Answer: B, D Explanation: If you are using the Automatic Undo Management feature, SMON is responsible for shrinking undo segments as needed and Oracle9i automatically creates a fixed number of undo segments per undo tablespace. Incorrect Answers A: SMON, not PMON background process, is responsible for shrinking undo segments as needed. C: You have not to create undo segments into an undo tablespace: it will be done by Oracle automatically. E: You don't have to create one undo tablespace per open instance in a Real Application Clusters environment. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-164 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 19-25 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 28: For the best performance, what should be done with blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database? A. They should be transferred across a high-speed cluster interconnect. B. They should be written to disk by the sending instance and read from disk by the receiving instance. Actualtests.com - The Power of Knowing 1Z0-030 C. They should be granted, by the Global Cache Service, an exclusive mode resource for each instance involved. D. They should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered. Answer: A Explanation: The blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database should be transferred across a high-speed cluster interconnect to increase th...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online