Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However, when you observe the Memory Advisor on a Friday, you find that the statistics are available only for two days, Thursday and Friday, of that week. What would have caused the statistics to be removed?()
Which of the following interfaces is required to implement Workload Partition Mobility? ()
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()
What is the purpose of configuring Workload Manager on a server used for development and QA?()
Which of the following is a correct statement about Workload Partitions (WPARs)?()
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile, and statistics to diagnose the possible causes of the performance degradation?()
Which IBM Tivoli Workload Scheduler report will provide the job history?()
In a Database Replay workload capture, what client request information is gathered?()