Examine this list of possible tasks:1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL.2. Ensure that TIMED_STATISTICS is set to TRUE.3. Set MAX_DUMP_FILE_SIZE to UNLIMITED and DIAGNOSTIC_DEST to an appropriate destination.4. Ensure that SQL_TRACE is set to TRUE.5. Enable tracing at the database instance level by using the DBMS_MONITOR.DATABASE_TRACE_ENABLE procedure.6. Enable tracing in the required session by using the DBMS_SESSION.SET_SQL_TRACE procedure.7. Run TKPROF with the EXPLAIN parameter on the output trace file.8. Run the trcsess utility on the output trace files, and then run TKPROF on the output of the trcsess utility.Select the minimum tasks to perform, in the correct order, to generate both a formatted trace file with timing information and an explain plan for each SQL statement for all sessions. (Choose the best answer.)
Examine the command to change a parameter value from the default to 50:SQL> ALTER SYSTEM SET OPTIMIZER_INDEX_COST_ADJ = 50;What is the effect of changing the value of the parameter? (Choose the best answer.)
You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for transactions. On investigation, you find that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:Which four can be possible reasons for the increased response time? (Choose four.)
Which two statements are true about gathering statistics? (Choose two.)
Which two statements are true about viewing the details of Real-Time Database Operations? (Choose two.)
In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the COUNTRY_ID column. You want to make the optimizer aware of this dependency when these columns are used together in WHERE clause predicates that contain equalities or in-lists.Which two methods achieve this? (Choose two.)
