You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:✑ analyze and compare the overall database workload with concurrency and transaction characteristics✑ find SQL statements that might get regressed because of the upgrade✑ analyze execution plans for SQL statements for which performance might get regressed✑ analyze the impact of new schema objects on database performanceWhich two tools would you recommend to achieve the objective? (Choose two.)
Which two are prerequisites for running the I/O calibration tool? (Choose two.)
You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.Which action would you take to achieve this? (Choose the best answer.)
Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events:Identify three possible reasons for the increased response time. (Choose three.)
Examine the parameters set for a database instance:An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slow response time of queries on these tables. On investigation, you notice that buffers are getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and SGA_TARGET parameters, but after some time, you notice the same issue again.Which two would you recommend as long-term solutions for this issue? (Choose two.)
Which three statements are true about the interpretation of an execution plan? (Choose three.)
