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

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

A. Increase the size of the undo tablespace and enable undo retention guarantee.

B. Increase the size of the database buffer cache.

C. Enable temporary undo.

D. Increase the size of the temporary tablespace or make it autoextensible.

E. Enable Automatic Segment Space Management (ASSM) for the undo tablespace.

Examine the parameters set for a database instance supporting a mixed workload:

The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:

Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)

A. Use a parallel hint in the queries.

B. Increase the number of DBWn processes.

C. Increase the value of the SORT_AREA_SIZE initialization parameter.

D. Increase the size of the temporary tablespace or add a new temporary tablespace.

E. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

F. Increase the size of the large pool.

Examine the initialization parameters set for a database instance:

The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.

To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.

What will you recommend to alleviate the issue? (Choose the best answer.)

A. Run the I/O calibration tool.

B. Configure the database instance to make asynchronous I/O available to DBWR.

C. Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.

D. Configure dedicated server connections for the applications.

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

A. gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics

B. using SQL plan directives to generate an optimal plan

C. setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true

D. creating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns

Your database supports an OLTP workload where a large number of syntactically similar queries are executed. Examine the Instance Efficiency Percentages in the Automatic Workload Repository (AWR) report of the last hour: Which two inferences can be drawn from the report?

A. The optimizer is waiting for resources during parsing of the queries.

B. The CPU is spending more time on pinning cursors in the library cache.

C. The database buffer cache is undersized and is causing contention.

D. Cursors are not getting shared in the library cache.