What could be the problem and solution for this?
A. The reserved pool is not configured. Configure the reserved pool.
B. The keep buffer pool is not configured. Configure the keep buffer pool.
C. The sequence was created with a CACHE of 100 numbers. Re-create the sequence with a higher CACHE number.
D. The sequence is aging out of the shared pool. Keep the sequence in the shared pool using the DBMS_SHARED_POOL.KEEP procedure.
Answer:D
What could be the problem and solution for this?
A. The reserved pool is not configured. Configure the reserved pool. B. The keep buffer pool is not configured. Configure the keep buffer pool. C. The sequence was created with a CACHE of 100 numbers. Re-create the sequence with a higher CACHE number. D. The sequence is aging out of the shared pool. Keep the sequence in the shared pool using the DBMS_SHARED_POOL.KEEP procedure.