Examine this query and output:SQL> select order_flag, cache_size, session_flag, keep_value,2 from user_sequences where sequence_name = SEQ1;O CACHE_SIZE S K --- ---------------- -- -Y 10 N NPerformance 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?
A. alter sequence seq1 cache 10000;
B. alter sequence seq1 order;
C. alter sequence seq1 noorder;
D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’) E. alter sequence seq1 keep;
Examine this query and output:SQL> select order_flag, cache_size, session_flag, keep_value,2 from user_sequences where s
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am