Oracle Metric sequence load elapsed time

Oracle Metric sequence load elapsed time

 

The sequence load elapsed time Oracle metric is the amount of elapsed time spent getting the next sequence number from the data dictionary.

If a sequence is cached, then this is the amount of time spent replenishing the cache when it runs out.

No time is charged when a sequence number is found in the cache.

For non-cached sequences, some time will be charged for every nextval call.