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

Annett

6 days 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

...

Garry

11 days ago

Option B looks promising, a larger cache can help reduce contention. But I'm not sure if 'alter sequence seal cache 10000' is the correct syntax.

upvoted 0 times

...

Royce

11 days ago

But altering the sequence to keep or order might help reduce contention.

upvoted 0 times

...

Kate

12 days ago

I disagree, I believe it's D and E.

upvoted 0 times

...

Royce

14 days ago

I think the answer is B and C.

upvoted 0 times

...

Dominic

16 days ago

But altering the sequence to keep or order might help reduce contention.

upvoted 0 times

...

Aliza

18 days ago

I disagree, I believe it's D and E.

upvoted 0 times

...

Dominic

28 days ago

I think the answer is B and C.

upvoted 0 times

...