Cache Sequence

Cache a sequence means hold just two values in memory, no matter the size of cache, So when any session ask for new value the Oracle simple increase the memory count in one, until it reach the cache number. When you restart the server then you loose all your unused cache number, so you might not use extremelly high cache value, a good advice is use a cache that will be consume in one work day.

My self , answering to Kishore at:

http://forums.oracle.com/forums/thread.jspa?messageID=2050687&#2050687