nerdexam
Oracle

1Z0-064 · Question #68

Examine the initialization parameters set for a database instance: The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small…

The correct answer is B. Configure the database instance to make asynchronous I/O available to DBWR. See the full explanation below for the reasoning.

Question

Examine the initialization parameters set for a database instance:

The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance. To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits. What will you recommend to alleviate the issue? (Choose the best answer.)

Exhibit

1Z0-064 question #68 exhibit

Options

  • ARun the I/O calibration tool.
  • BConfigure the database instance to make asynchronous I/O available to DBWR.
  • CSpread the data files over multiple disks, controllers, and I/O buses to ensure that there are no
  • DConfigure dedicated server connections for the applications.

How the community answered

(40 responses)
  • A
    3% (1)
  • B
    83% (33)
  • C
    5% (2)
  • D
    10% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-064 Practice