-L
Sent: Friday, June 14, 2002 3:23 AM
Subject: sequence question
Hi List ,
I want to create a sequence which will be used by
some external process to generate some unique number . since this sequence
will be used very frequently I would prefer to cache around 1 numbers . Am
loose numbers after an Import / Export.
Luck,
Ramon
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Thursday, June 13, 2002 8:23
PM
Subject: sequence question
Hi List ,
I want to create a sequence which will be used by
some
what
do you mean about losing numbers after an import/export?
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002
10:44 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: sequence question
Bigp
Remember that when you
Bill,
When you do an export you have sequence numbers
in cache.
Ramon
- Original Message -
From:
Magaliff, Bill
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 10:53
AM
Subject: RE: sequence question
what
do you mean about losing
to loose numbers
?
Did any of you guys tried caching high number such
as 1 or 100 .
Thanks ,
Bp
- Original Message -
From:
Magaliff, Bill
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 8:53 AM
Subject: RE: sequence question
what
do
Acording to the manuals SEQUENCE_CACHE_ENTRIES is an obsolete
parameter for 8.1.7
Ramon
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 12:49
PM
Subject: Re: sequence question
while going throgh oracle
Hi List ,
I want to create a sequence which will be used by
some external process to generate some unique number . since this sequence will
be used very frequently I would prefer to cache around 1 numbers . Am I
going to loose some numbers ?
what is SEQUENCE_CACHE_ENTRIES and how does it
Short answer - yes you could loose some numbers.
Have a look at http://www.ixora.com.au/scripts/library.htm and the
unload_sequences.sql and keep_sequences.sql which mention that you can lose when:
Shutdown abort is done
the sequence gets aged out of the library cache
The