Get Oracle 1Z0-064 Exam Dumps

You upgrade your database from Oracle Database 11g to 12c. You capture execution plans for a resource-intensive SQL workload before the upgrade. After the upgrade, you load the plans into the SQL Management Base.

Examine the parameters set for the instance:

Which two statements are true?

Which three statements are true about the TEST EXECUTE method of the SQL Performance Analyzer?

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.)

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.)

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.)