Oracle Database 11g: Performance Tuning 試験
Question No : 1
You created two services HR and FINANCE on a single instance database. These services are used by the middle-tier applications to connect to the database by using connection pools. The applications have various modules and you asked the developers to invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure to set the module name and action in the code for the application.
As part of performance management, you want to gather statistics for these modules and see the amount of workload created by these modules.
What would you recommend to accomplish the task?
Question No : 2
Your database supports many applications running on the middle tier. Many applications users create jobs for which you want to statistically measure workload as a part of performance management.
What would you do to accomplish the task?
Question No : 3
Your database has the HR and Reporting applications. The HR application does most of the transactions on the database and the Reporting application does most of the batch processing operations. The Reporting application has more workload during nonpeak hours. Both the HR and Reporting applications run on the middle tier using connection pooling for connecting to database.
You want to statistically measure the workload generated by both the applications and set priority for the workload generated by the applications. Which option would help you achieve this?
Question No : 4
Identify situations in which collecting statistics at the service level helps diagnosing performance problems. (Choose all that apply.)
Question No : 5
You are managing an online transaction processing (OLTP) system. The database is supporting a large number of applications using connection pools to connect to the database.
Which method would you use for performance management?
Question No : 6
You are managing an online transaction processing (OLTP) database with multiple applications. The applications support a large number of users and most of the applications execute groups of SQL that run together.
Which option would you use to monitor the performance issues for users of these applications?
Question No : 7
The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.
What would you suggest to analyze this performance problem for the user?
Question No : 8
View the Exhibit and examine portions of two ASH reports generated for the same time period. The second report was generated after the ASH data is flushed to disk.
Why is the sample count reduced in the second report?
Question No : 9
View Exhibit1 and examine a portion of Active Session History(ASH) report.
View Exhibit2 to examine the tablespaces.
Which action would you suggest after analyzing the output?
Question No : 10
View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.
Which two can be inferred from the output? (Choose two.)
Question No : 11
View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.
Which statement is true about the report?
Question No : 12
while diagnosing performance problems for a database, you find Buffer Busy wait is the reason from V$ views. But the Automatic Database Diagnostic Monitor (ADDM) report does not reflect the Buffer Busy findings.
Why does the Buffer Busy finding not appear in the ADDM report?
Question No : 13
After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue.
View the Exhibit.
What is the significance of the Benefit(%) column in the Exhibit?
Question No : 14
View the Exhibit and examine the Automatic Database Diagnostic Monitor (ADDM) performance analysis.
Identify the correct description of the Impact(%) column in the Exhibit.
Question No : 15
You analyze an Automatic Database Diagnostic Monitor (ADDM) report to identify the component that contributes most to the database time. Which is the correct description of database time?