Examine an extract from a PGA Memory Advisory for your database: Which two inferences are correct? (Choose two.)

A. Automatic management of PGA memory is disabled.

B. The current PGA size requires the use of a temporary tablespace for sorting operations.

C. The current PGA size is sufficient and does not require the memory manager to allocate more memory.

D. PGA size should be increased at least four times its current size for significant improvement in performance and disk space management.

Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)

A. ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.

B. ADDM runs in Partial mode to analyze any hung database issues.

C. Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.

D. Real-Time ADDM is automatically invoked by ADDM at the end of every hour.

The SALES table has over one million rows. Statistics for the SALES table and its dependent objects are gathered by the Oracle AutoTask task during a predefined maintenance window.

Examine the query:

Which two actions can improve the accuracy of cardinality estimates for this query?

A. ensuring that histograms exist for the CUST_ID and PROD_ID columns

B. setting the OPTOMIZER_DYNAMIC_SAMPLING parameter to 4 to augment the default standard statistics

C. setting the FORCE parameter of the GATHER_*_STATS procedure to TRUE and gathering statistics for the SALES table and its dependent objects

D. gathering system statistics during peak workload time to augment the standard statistics

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

A. The SQL statements in the STS are compared only on elapsed time for the pre-change and post-change trials.

B. The execution statistics generated for SQL statements are analyzed to check whether they have improved or regressed.

C. An execution plan and statistics are generated for SQL statements only in the pre-change trial.

D. The SQL statements in the SQL Tuning Set (STS) are executed at least twice for both pre-change and post-change trials.

E. An execution plan and statistics are computes for each SQL statement in the STS.

Your database supports multiple applications. The applications run on the middle tier and use connection for connecting to the database.

You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.

What action must you perform to achieve this?

A. Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.

B. Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.

C. Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.

D. Create services for the applications and set a relative priority by assigning them to application users.