Re: Do Sequences Have Any Disadvantages?

From: ZEITGEIST <restaurant_at_the.end.of.the.universe>
Date: 1997/02/18
Message-ID: <5eba2a$acp@news2.ee.net>#1/1

In article <33035A4E.6AF9_at_glaxowellcome.com>, jmj22026_at_glaxowellcome.com says...
>
>Just be carefull to put a "no-cache" option on a
>sequence. The default is to cache sequences. So
>when the instance is started it will cache a
>certain number from your sequences. This makes
>selects from it faster, but when ever the server
>goes down (either from shut-down or crash) you
>loose that set of numbers.
>
>John Jones
>Oracle Consultant

Is this a "bad" thing ? Depending on the number you cache, the benefits of the fast select may far outweigh the lost numbers. Also, if I am not mistaken, Oracle will only go out and grab the next set of numbers when it runs out. Therefore, the only time you would lose the entire set of numbers is if the crash or shutdown occurs right after a refresh. Heck, you may only lose a few.

Just my two cents....

Brett C.
zgeist_at_ee.net Received on Tue Feb 18 1997 - 00:00:00 CST