Which two commands are used to migrate IBM Tivoli Workload Scheduler to version 8.5 on a UNIX system?()
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?()
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()
Which three statements are true about Automatic Workload Repository (AWR)?()
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()
What is the purpose of configuring Workload Manager on a server used for development and QA?()
The workload requirement for a Web server running in Micro-Partitioned p5-550 has increased 300 percent over the past six months. The initial partition definitions assigned 0.5 processing units and one virtual processor to the Web server partition. Three months previously, an additional 0.5 CPU was added to the Web server partition. When the technical specialist attempted to allocate a further 0.5 CPU to this partition, no additional performance was achieved. Which of the following actions would most likely resolve the problem?()
When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?()