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

Hui

2 months ago

Seriously, SQL Plan Directives? Sounds like a job for the database police.

upvoted 0 times

...

Catrice

2 months ago

I'm all about those adaptive plans. Let's get that optimizer working overtime!

upvoted 0 times

Lisandra

1 months ago

True, both D) optimizer_adaptive_plans=TRUE and E) optimizer_adaptive_statistics = TRUE are important for optimizing SQL Plan Directives.

upvoted 0 times

...

Pamella

2 months ago

But don't forget about E) optimizer_adaptive_statistics = TRUE, that also plays a role in activating SQL Plan Directives.

upvoted 0 times

...

Shaun

2 months ago

I agree, optimizer_adaptive_plans=TRUE is the correct parameter change for that.

upvoted 0 times

...

Filiberto

2 months ago

I think the parameter change that activates the generation and use of SQL Plan Directives is D) optimizer_adaptive_plans=TRUE

upvoted 0 times

...

Lilli

3 months ago

C'mon, who doesn't love a good dynamic sampling? That's the way to go, folks!

upvoted 0 times

Kimberely

1 months ago

I always make sure to enable optimizer_dynamic_sampling.

upvoted 0 times

...

Ronnie

1 months ago

I agree, it's a game changer for sure.

upvoted 0 times

...

Zachary

2 months ago

Dynamic sampling is definitely the way to go!

upvoted 0 times

...

Rhea

2 months ago

E) optimizer_adaptive_statistics = TRUE

upvoted 0 times

...

Octavio

2 months ago

D) optimizer_adaptive_plans=TRUE

upvoted 0 times

...

Avery

2 months ago

C) optimizer_dynamic_sampling=11

upvoted 0 times

...

Tambra

2 months ago

B) optimizer_capture_sql_plan_baselines_TRUE

upvoted 0 times

...

Natalie

2 months ago

A) optimizer_features_enable=12.2.0.1

upvoted 0 times

...

Marla

3 months ago

I see your point, Millie, but I still think D) optimizer_adaptive_plans=TRUE is the best choice.

upvoted 0 times

...

Millie

3 months ago

I'm not sure, but I think E) optimizer_adaptive_statistics = TRUE could also activate SQL Plan Directives.

upvoted 0 times

...

Melodie

3 months ago

I agree with Marla, optimizer_adaptive_plans=TRUE makes sense for SQL Plan Directives.

upvoted 0 times

...

Marla

3 months ago

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

upvoted 0 times

...