1Z0-084Preview

Which three types of statistics are captured by Statspack with snap level 6? (Choose three.)

You execute the following:
EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

You want to reduce the amount of db file scattered read that is generated in the database.
You execute the SQL Tuning Advisor against the relevant workload.
Which two can be part of the expected result? (Choose two.)

Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

Which two types of performance problems are reported by ADDM for PDBs? (Choose two.)

What is the right time to stop tuning an Oracle database?

Database performance degraded between 23:15 and 23:30 for the last three nights. The AWR snapshot interval is one hour. The ADDM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

Examine this AWR report excerpt:

You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?

Examine this output of a query of V$PGA_TARGET_ADVICE:

Which statements is true?

Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?

Which two statements are true about Data Pump import for objects that used the In Memory (IM) column store in their source database? (Choose two.)

For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL performance? (Choose two.)

You must write a statement that returns the ten most recent sales. Examine this statement:

Users complain that the query executes too slowly. Examine the statement's current execution plan:

What must you do to reduce the execution time and why?

You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:B1
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:

There is no index on the CITY_ID column.
Which two options improve the performance? (Choose two.)

Which two statements are true about space usage in temporary tablespaces? (Choose two.)

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

Which two statements are true about session wait information contained in v$session or v$session_wait? (Choose two.)

Accessing the SALES table causes excessive db file sequential read wait events.
Examine this AWR excerpt:

Now, examine these attributes displayed by querying DBA_TABLES:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits? (Choose two.)

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance? (Choose two.)

A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.

Which two actions can help reduce the number of these waits? (Choose two.)

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true? (Choose two.)

This error occurred more than four hours ago in the database:
ORA-04036 PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
You want to know which process and query were at fault.
Which two views should you use for this purpose? (Choose two.)

Examine this statement and output:

Which two situations can trigger this error? (Choose two.)