Examine the parameters set for a database instance:The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)
In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.Which two statements are true? (Choose two.)
Examine the parameters set for a database instance supporting a mixed workload:The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)
Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currently cached in the library cache to receive recommendations about the usage of indexes and materialized views.What should you do to achieve this? (Choose the best answer.)
Which two statements are true about ADDM? (Choose two.)
Examine the initialization parameters set for a database instance:The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.What will you recommend to alleviate the issue? (Choose the best answer.)
