Re: Sequence Caches

From: John Jones <jmj22026_at_us0n05.glaxo.com>
Date: 1996/07/10
Message-ID: <31E3CA3F.4322_at_us0n05.glaxo.com>#1/1

Sequences are chached in memory when the oracle instance is started. If you are using sequences for just random numbers this is ok. We used them for unique numbers and wanted them in order with out losing any numbers. Since they are cached in memory, any glich to memory causes numbers to be lost. Shutdowns, if it be normal or not will cause the numbers to be lost and a new set cached to memory when you restart the instance. If this is ok, then use it, if not create your sequences with the "NO CACHE" option.

John Jones
Oracle Consultant
jmj22026_at_us0n05.glaxo.com Received on Wed Jul 10 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Alireza Assadzadeh: "Re: Web access to Oracle."
Previous message: bjidico_at_public.bta.net.cn: "Problem installing Oracle7.3"
In reply to: John Dennis: "Sequence Caches"
Next in thread: Alireza Assadzadeh: "Re: Web access to Oracle."
Reply: Eugene Freydenzon: "Re: Sequence Caches"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message