Category: 1z0-043 (v.2)

Exam 1z0-043: Database 10g: Administration II (October 26th, 2014)

Which advisory component would you refer to, in order to determine that required size of the database buffer c

You observe that a database performance has degraded over a period of time. While
investigating the reason, you find that the size of the database buffer cache is not large
enough to cache all the needed data blocks. Which advisory component would you refer to,
in order to determine that required size of the database buffer cache?

What action would you take to minimize the waits?

Exhibit

In your production database, the total waits and the time waited for log file parallel write are
significantly high. While investigating the reason, you find that there are three redo log
groups with two members in each group, and all redo log members are places on a single
physical disk. What action would you take to minimize the waits?
PassCertification.com- 1z0-043 Exam Questions and Answers 2


Page 1 of 2212345...1020...Last »