You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high.Which two can be possible resolutions for this issue? (Choose two.)
Examine the query and its output:Which two inferences can be definitely derived from this output? (Choose two.)
You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables.What is the recommended action to improve performance? (Choose the best answer.)
Your database supports an OLTP system.Examine the parameter values configured in your database:sga_max_size = 480Msga_target = 480Mpga_aggregate_target = 160MThe CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111,2222, and 3333.You execute the commands:SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(SH,CUSTOMERS);PL/SQL procedure successfully completed.SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);Index created.You then perform a series of INSERT, UPDATE, and DELETE operations on the table.View the Exhibit to examine the query and its execution plan.Which two options can improve the performance of the query without significantly slowing down the DML operations? (Choose two.)
Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.Which three objectives can be achieved by the Resource Manager? (Choose three.)
