1z0-054 Oracle 11i Braindump
ExamSoon 1z0-054 Exams
Oracle Oracle Database 11g: Performance Tuning
O rder : 1z0-054 Exam
Practice Exam: 1z0-054
Exam Number/Code: 1z0-054
Exam Name: Oracle Database 11g: Performance Tuning
Questions and Answers: 192 Q&As
Free 1z0-054 Braindumps
Exam : Oracle 1Z0-054
Title : Oracle Database 11g: Performance Tuning
1. You are working on an online transaction processing (OLTP) system. You detected free buffer waits events for your
database instance running in a machine that has multiple CPUs. You increased the database buffer cache size as the
first step. After a few hours of work on the database, further investigation shows that the same event is being
recorded.
What would be your next step to avoid this event in future?
A. Decrease the value of the DBWR_IO_SLAVES parameter.
B. Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
C. Increase the value of the DB_WRITER_PROCESSES parameter.
D. Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
Answer: C
2. Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
A. A part of SGA memory is used to store ASH data as rolling buffer.
B. The ASH data can be analyzed between any two small time intervals.
C. All ASH data in memory are flushed to disk by MMON in every 3 seconds.
D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
Answer: AB
3. View the Exhibit and examine a portion of the output obtained from the following query:
SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)
A. DB time includes the wait time of all the nonidle and idle user sessions.
B. SQL execute elapsed time includes the time spent in performing fetches of query results.
C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.
D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.
E. DB time includes the connection mana