[2026] Oracle Database 12c: Performance Management and Tuning

문제1

For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)

A. to find the exact number of executions of a specific query in a session in the last two minutes

B. to identify which module in an application was being executed in a session

C. to identify a scheduler job that is not responding

D. to investigate intermittent performance problems in a session, only when the problem lasted less than five minutes in the last twelve hours

E. to find the amount of Program Global Architecture (PGA) memory being currently consumed by a session

정답: B,E

문제2

Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)

A. generating an execution plan and statistics for selective SQL statements captured in an STS

B. generating only execution plans on a test database without actually running SQL statements.

C. loading performance data and execution plans from an STS.

D. generating both execution plans and statistics for each SQL statement in an STS by actually running the SQL statements on a test database.

E. executing SQL statements in a SQL Tuning Set (STS) on a test database by using database links to the production database.

정답: A,B,E

문제3

In which three scenarios would you recommend the use of the SQL Performance Analyzer?

A. to analyze the impact of using bind variables for syntactically similar SQL statements

B. to identify SQL statements whose performance may have regressed due to a hardware upgrade

C. to analyze the impact of network and interconnect changes on database workload

D. to identify SQL statements that require SQL profiles

E. to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c

F. to analyze the impact of new indexes and materialized views on the SQL statements executed by an application

정답: B,C,D

문제4

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 the relative priority of services within an instance by mapping the services directly to consumer groups.

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

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

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

정답: A

문제5

You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded performance of some queries. The SQL plan baselines imported from the previous version are present for the queries and are loaded to the SQL Management Base as accepted plans. On further investigation, you find that better plans are generated but not used by the optimizer.
Examine the parameters set for the instance:

Which three tasks would you perform to improve the performance of these queries? (Choose three.)

A. Gather statistics for the objects used in the queries.

B. Create a SQL Tuning Set (STS) and run it through the SQL Access Advisor to generate recommendations.

C. Use the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to evolve new plans and fix the plans for the statements.

D. Create an STS and run it through the SQL Tuning Advisor to generate recommendations.

E. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

F. Use the DBMS_SPM.ALTER_SQL_PLAN_BASELINE function to alter the accepted plans as fixed plans.

정답: A,B,C

문제6

You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)

A. Create a single baseline template.

B. Create repeating baseline templates.

C. Create database services and make sure that user connections use them to connect to the database instance.

D. Create AWR baselines.

E. Create SQL plan baselines.

정답: C

문제7

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. setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true

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

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

D. using SQL plan directives to generate an optimal plan

정답: B,C

Oracle Database 12c: Performance Management and Tuning - 1z1-064무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트