To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the query: The table is stored in a tablespace that has Automatic Segment Space Management (ASSM) enabled. The tablespace is created with a standard block size of 8192 bytes. Which three can be reasons for the slow response time of the queries? (Choose three.)
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?
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.)
Examine the parameters set for your database instance: To investigate the slow response time of queries on the TRANS table, you gather table and execute the query: The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained. Which two actions would you recommend to improve query response time?
You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%. Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)
Which three actions should you perform to reduce shared pool fragmentation and avoid the “ORA-04031: unable to allocate .... bytes of shared memory” error for the shared pool? (Choose three.)