Big Cyber Monday Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle Database 19c: Performance Management and Tuning 1z0-084 Question # 8 Topic 1 Discussion

Oracle Database 19c: Performance Management and Tuning 1z0-084 Question # 8 Topic 1 Discussion

1z0-084 Exam Topic 1 Question 8 Discussion:
Question #: 8
Topic #: 1

A database supporting a mixed workload is hosted on a server with 64 CPUs.

A large number of free buffer waits and buffer busy waits occur affecting performance.

The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.

Examine these parameter settings:

1z0-084 Question 8

Which two actions can help reduce the number of these waits7


A.

increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128


B.

Increasing the size of MEMORYTARGET


C.

setting dbwr_io_slaves to 64


D.

increasing the value of DBWRITERPROCESSES to 64,


E.

reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64


Get Premium 1z0-084 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.