Exam 1z0-078 topic 1 question 58 discussion

Actual exam question from Oracle's 1z0-078

Question #: 58
Topic #: 1

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

A. exec sys.dbms_shared_pool.keep(‘SEQ1’,’Q’)
B. alter sequence seq1 cache 10000;
C. alter sequence seq1 noorder;
D. alter sequence seq1 keep;
E. alter sequence seq1 order;

Show Suggested Answer

Suggested Answer: BC 🗳️

by [deleted] at April 4, 2025, 10:23 a.m.

Comments

Submit Cancel

shaw2000

2 days, 21 hours ago

Selected Answer: BC

To reduce SQ enqueue contention on a frequently used RAC sequence, you should: ✔ Increase the CACHE size Larger cache reduces how often instances must acquire the SQ enqueue. ✔ Disable ORDER ORDER forces global ordering across RAC nodes, which dramatically increases SQ enqueue contention. NOORDER allows each instance to allocate cached ranges independently.

upvoted 1 times

...

Most Voted

Save Cancel

Loading ...