Re: Caching in Sequence generators

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 22 Apr 1999 20:45:12 +0100
Message-ID: <924810440.20206.1.nnrp-03.9e984b29@news.demon.co.uk>

And I should have added that one of the things that flushes sequences is if you have a busy dictionary cache, and the
number of sequences you use is higher
than the sequence_cache_entries
init.ora parameter (although it looks as if that parameter is no longer the hard limit it used to be).

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

>However, your note reminded me that one of the
>things that makes sequences miss chunks is
>if they are flushed from the sequence cache
>(i.e. v$rowcache area), as the following shows:
Received on Thu Apr 22 1999 - 14:45:12 CDT