You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report:
Which three statements are true in this scenario? (Choose three.)
Answer : B, D, E
Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)
Answer : B, D
Your database supports an OLTP workload.
An application frequently performs update operations on an indexed column of a table; some bulk delete and insert operations are also performed.
The table is created in a locally managed tablespace with manual segment space management.
A user complains about poor response time when querying the table.
The queries mostly perform index range scans.
You notice a high number of buffer busy waits and contention on segment headers.
Which three would you investigate further to diagnose the poor response time?
Answer : B, C, E
The CUSTOMERS table has 55,500 rows and 620 distinct values in the CUST_CITY_ID column. The number of popular values is 54 and less than 99% of the rows contain popular values.
Which type of histogram should you create to accurately determine the cardinality estimate on the CUST_CITY_ID column?
Answer : B
To diagnose the performance degradation of your production database, you execute these queries:
Segment space management is manual for some of the tablespaces.
What can be the reason for the performance degradation?
Answer : E
In which three scenarios can you use ADDM to get recommendations?
Answer : A, C, E
Examine the parameters set for your database instance:
You are administrating a database that supports a DSS workload. You make some changes to the sizes of memory components. Consequently, you receive this error:
Which three actions might resolve the issue?
Answer : C, D, F