What are the least elevated values of STATISTICS_LEVEL and CONTROL_MANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?
You need to transport performance data from a Standard Edition to an Enterprise Edition database.What is the recommended method to do this?
A database supporting a mixed workload is hosted on a server with 64 CPUs.A large number of free buffer waits and buffer busy waits occur affecting performance.The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.Which two actions can help reduce the number of these waits? (Choose two.)
Which two types of performance problems are reported by ADDM for PDBs? (Choose two.)
Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?
Which application lifecycle phase could be managed reactively?
