1Z0-068 · Question #32
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 N…
The correct answer is A. alter sequence seq1 cache 10000; D. exec sys.dbms_shared_pool.keep (`SEQ1', `Q'). D: The KEEP procedure keeps an object in the shared pool. Once an object has been kept in the shared pool, it is not subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought into the shared pool, several objects may…
Question
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 N 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?
Options
- Aalter sequence seq1 cache 10000;
- Balter sequence seq1 order;
- Calter sequence seq1 noorder;
- Dexec sys.dbms_shared_pool.keep (
SEQ1',Q') - Ealter sequence seq1 keep;
How the community answered
(37 responses)- A76% (28)
- B5% (2)
- C16% (6)
- E3% (1)
Explanation
D: The KEEP procedure keeps an object in the shared pool. Once an object has been kept in the shared pool, it is not subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought into the shared pool, several objects may need to be aged out to create a contiguous area large enough. https://ora600tom.wordpress.com/2015/01/09/enq-sq-contention/ https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_shpool.htm#i999221
Topics
Community Discussion
No community discussion yet for this question.