Oracle Exam 1Z0-084 Topic 3 Question 17 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 17
Topic #: 3

[All 1Z0-084 Questions]

Examine these statements and output:

What parameter change activates the generation and use of SQL Plan Directives7

Aoptimizer_features_enable=12.2.0.1

Boptimizer_capture_sql_plan_baselines_TRUE

Coptimizer_dynamic_sampling=11

Doptimizer_adaptive_plans=TRUE

Eoptimizer_adaptive_statistics = TRUE

Show Suggested Answer

Suggested Answer: E

The optimizer_adaptive_statistics parameter, when set to TRUE, enables the optimizer to use adaptive statistics, such as SQL Plan Directives, to help improve plans by automatically adjusting them based on the actual execution statistics.

Oracle Database SQL Tuning Guide, 19c

by Anabel at Aug 28, 2024, 07:23 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-084 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Marla

5 days ago

I think the correct answer is D) optimizer_adaptive_plans=TRUE.

upvoted 0 times

...