Clarification on sequences with CACHE parameter

From: Madhu Cherukuri <madhu.cherukuri_at_usa.net>
Date: Tue, 10 Nov 1998 08:00:54 -0800
Message-ID: <WqZ12.2467$C5.3606183@WReNphoon1>

Hi Rajesh,

The Manual states the following

When the last of the sequence numbers in the cache has been used, Oracle reads another set of numbers into the cache.

So, it the at the point when a user reads the last number from the cache, another set of numbers is read in to the cache.

HTH Madhu Cherukuri

-**** Posted from Supernews, Discussions Start Here(tm) ****- http://www.supernews.com/ - Host to the the World's Discussions & Usenet Received on Tue Nov 10 1998 - 10:00:54 CST