Oracle 1Z0-064 dumps - 100% Pass Guarantee!

Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

A. Use the Resource Manager.

B. Enable SQL Trace at the session level.

C. Create a service.

D. Use a dedicated server configuration.

E. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.

For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendations by default? (Choose three.)

A. for network stack-related bandwidth contention

B. for concurrency issues because of buffer busy problems

C. for high-load PL/SQL execution and compilation, and high-load Java usage

D. for application-level lock contention.

You want to capture the performance of your database during the last ten days of the first quarter of the current financial year, so that you can compare this performance against the remaining quarter ends of the current financial year.

Which method should you use? (Choose the best answer.)

A. Create a static baseline that can be used with AWR compare reports.

B. Create a new moving window baseline and enable adaptive thresholds for relevant metrics.

C. Use a repeating baseline template to create and drop baselines based on a repeating time schedule and set adaptive thresholds at a high significance level.

D. Use fixed baseline templates to create a new moving window baseline and set relevant warning alerts that are computed as a percentage multiple of the maximum value observed for the data in the moving window baseline.

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

A. 1, 2, 5, 8

B. 1, 3, 6, 7

C. 2, 4, 5, 8

D. 1, 3, 4, 5, 6, 7

E. 1, 2, 4, 8

Examine the parameters set for your database instance: You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.

Which two actions would you recommend to improve performance? (Choose two.)

A. Create the KEEP cache and cache the tables used in the queries.

B. Set the CURSOR_SHARING parameter to FORCE.

C. Use bind variables instead of literals.

D. Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.

E. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.