Oracle Exam 1Z0-078 Topic 9 Question 21 Discussion

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

Question #: 21
Topic #: 9

[All 1Z0-078 Questions]

Examine this query and output:

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.

The SEQ1 sequence is incremented from all instances equally and is frequently used.

Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

Aexec sys.dbms shared pool.keep('SEQ1','Q'>

Balter sequence seal cache 10000;

Calter sequence seql noorder;

Dalter sequence seql keep;

Ealter sequence seql order;

Show Suggested Answer

Suggested Answer: B, D

by Man at Jul 11, 2024, 08:34 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Yoko

2 months ago

Wait, is this a trick question? I feel like the real answer is to sacrifice a goat to the Oracle gods and hope they reduce the contention. These options are as confusing as trying to understand a DBA's stand-up comedy routine.

upvoted 0 times

...

France

2 months ago

I think options A and C are the way to go. Keeping the sequence in the shared pool and removing the ordering constraint should help reduce the contention. But I'm not sure about the syntax either.

upvoted 0 times

Levi

19 days ago

Let's try executing both statements and see if it helps reduce the SQ enqueue contention.

upvoted 0 times

...

Blossom

27 days ago

Option C could also help by removing the ordering constraint on the sequence.

upvoted 0 times

...

Golda

1 months ago

I agree, option A seems like a good choice to keep the sequence in the shared pool.

upvoted 0 times

...

Lisha

2 months ago

Haha, 'alter sequence seql keep' in option D sounds like a joke. How can you keep a sequence? These options are really making me scratch my head.

upvoted 0 times

...

Annett

2 months ago

Hmm, 'alter sequence seql noorder' in option C seems like it could help, as removing the ordering constraint might reduce contention. But I'm not sure if 'seql' is a typo.

upvoted 0 times