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? A. Increase the log buffer size. B. Rebuild indexes on SPCT table. C. Decreasing…
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? A. because…
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…
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…
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? A. Service aggregation for action within application…
Identify situations in which collecting statistics at the service level helps diagnosing performance problems. (Choose all that apply.) A. in a database where you want to monitor and diagnose individual sessions B. in a database where you want to statistically…
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…
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? A. Assign resource consumer…
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…
Your database has the ACCTG service configured for an accounting application that runs on a middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled tracing at the service level by executing the following command: SQL> exec…