Oracle Logbook

September 6, 2007

Cache Sequence

Filed under: Uncategorized — Helio Dias @ 12:36 pm

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:

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: