<< Prev Question Next Question >>

Question 8/49

You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded performance of some queries. The SQL plan baselines imported from the previous version are present for the queries and are loaded to the SQL Management Base as accepted plans. On further investigation, you find that better plans are generated but not used by the optimizer.
Examine the parameters set for the instance:

Which three tasks would you perform to improve the performance of these queries? (Choose three.)

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (49q)
Question 1: For your database some users complain about not being able t...
Question 2: Examine the query and its output: (Exhibit) Which two infere...
Question 3: Which three methods can you use to create a pre-change SQL t...
Question 4: You are administering a database that supports an OLTP workl...
Question 5: Which two statements are true about Active Session History (...
Question 6: Examine the partial AWR report taken for a time period of 60...
Question 7: You want to capture the performance of your database during ...
Question 8: You are administering a database that supports a mixed workl...
Question 9: Examine the output of the query executed to diagnose the rea...
Question 10: Which two actions should you take to monitor the throughput ...
Question 11: Examine the structure of the EMPLOYEEStable. (Exhibit) EMPLO...
Question 12: Examine the query and its output: (Exhibit) Which two statem...
Question 13: Examine the partial PLAN_TABLEoutput: (Exhibit) Which is the...
Question 14: Which three statements are true about the interpretation of ...
Question 15: Which two statements are true about viewing the details of R...
Question 16: Users complain about increased response time for queries in ...
Question 17: Which two statements are true about gathering statistics? (C...
Question 18: Which two statements are true about DB timein V$SYS_TIME_MOD...
Question 19: You want to capture AWR data to monitor performance variatio...
Question 20: Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNTpar...
Question 21: Which two situations can lead to sparsely populated index bl...
Question 22: You are administering a database that supports a mixed workl...
Question 23: Examine the parameters set for your database instance: (Exhi...
Question 24: In which three situations does DB timealways increase? (Choo...
Question 25: You are administering a database that supports an OLTP workl...
Question 26: You are administering a database that supports an OLTP workl...
Question 27: Examine the command to change a parameter value from the def...
Question 28: Examine the parameters set for a database instance supportin...
Question 29: You define the warning threshold for the tablespace usage me...
Question 30: For which three problem categories does Automatic Database D...
Question 31: Examine the parameters set for a database instance: (Exhibit...
Question 32: Examine this list of possible tasks: 1. Ensure that STATISTI...
Question 33: In your database, the locally managed tablespace, USERS, has...
Question 34: Which two statements are true about Compare Period ADDM? (Ch...
Question 35: You are administering a database that supports an OLTP workl...
Question 36: Examine the parameters set for your database instance: (Exhi...
Question 37: You are administering a database that supports a DSS workloa...
Question 38: Your database supports a DSS system. Examine the parameter v...
Question 39: Your database supports multiple applications. The applicatio...
Question 40: Examine the parameters set for your database instance: (Exhi...
Question 41: You plan to upgrade your production database from Oracle Dat...
Question 42: Your database supports a DSS workload. In an application, a ...
Question 43: In the CUSTOMERStable, the values in the CUST_STATEcolumn ar...
Question 44: In your database, the measured 99th percentile value is used...
Question 45: Which two result in the least internal fragmentation within ...
Question 46: Your database supports an OLTP system. Examine the parameter...
Question 47: Examine the parameters set for a database instance: (Exhibit...
Question 48: Which two are prerequisites for running the I/O calibration ...
Question 49: Examine the partial TOP 10 Foreground Events by Total Wait T...