High Misses on sequence IDGEN1$
11.2.0.3.0 8-node RAC
I've been looking at high misses on dc_sequences in v$rowcache. I've increased the cache_size on many of the sequences in the application and observed that the last_number increments appropriately, so I believe those changes have worked properly. What I've noticed is that the miss ratio is not dropping. So I started looking more closely at all sequences and have found SYS.IDGEN1$ that is incrementing rapidly - approximately 10,000 values per minute (166 per second). Currently the cache_size for IDGEN1$ is 1,000.
What is this sequence used for?
Is it safe to increase this SYS sequence's cache_size?
I've been looking at high misses on dc_sequences in v$rowcache. I've increased the cache_size on many of the sequences in the application and observed that the last_number increments appropriately, so I believe those changes have worked properly. What I've noticed is that the miss ratio is not dropping. So I started looking more closely at all sequences and have found SYS.IDGEN1$ that is incrementing rapidly - approximately 10,000 values per minute (166 per second). Currently the cache_size for IDGEN1$ is 1,000.
What is this sequence used for?
Is it safe to increase this SYS sequence's cache_size?
0