Which command is issued on an IBM Tivoli Workload Scheduler master to determine link status and collect into a user created report? ()
Which command starts Workload Manager?()
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.)
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
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 two statements about workload capture and replay operations are true?()
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 command starts Workload Manager?()
Which two statements are true about the Automatic Workload Repository (AWR)()
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?()