Topic: Oracle 12c, sequence, library cache: mutex X
There is a basis of Oracle 220.127.116.11.0
In basis some tables to which there is an intensive insertion of the data (as a group about 3 billion lines a day) are created
In each table the NUMBER-field which on the trigger is filled from one sequence (1 sequence on some tables) is created.
In a top of waitings are visible "library cache: mutex X" on requests of obtaining of values from sequence (select <sequence_name>.nextval from dual).
CACHE in sequence it is installed (100000).
Prompt, whether it is possible to reduce somehow waitings "library cache: mutex X" at frequent reversal to sequence, or it is an expected situation and somehow to affect on it does not turn out?
Tried to apply DBMS_SHARED_POOL.KEEP to sequence - results did not bring (waitings did not decrease).
DBMS_SHARED_POOL.MARKHOT To sequence it was not possible to apply - object type not supported.