| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OPS Sequences: nocache == order ??
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C25391.97FF00B0"
------_=_NextPart_001_01C25391.97FF00B0
Content-Type: text/plain;
charset="iso-8859-1"
It looks like when option "ORDER" is used Oracle guarantees the generated values will be in order since the "CACHE" option will be ignored by Oracle even if it was requested.
This is in the parallel mode.
Look at note: Note:1031850.6
Waleed
-----Original Message-----
Sent: Tuesday, September 03, 2002 6:00 PM
To: Multiple recipients of list ORACLE-L
I'm managing an OPS configuration (4x HP 9000/N, HP-UX 11/64 , RDBMS
8.1.7.1)
and I'm having an application dependency on a temporal order of sequence
numbers.
With OPS that becomes a problem because each node caches a set of sequence
numbers
(20 by default). Oracle has an option, specifically for that situation,
namely "ORDER".
My question is whether ORDER is the same thing as NOCACHE and whether it is
possible
to have a NOCACHE sequence which will return numbers in an incorrect order
(larger number
before the smaller one).
Please, o OPS gods and godesses, help me out and I'll sacrifice you a beer
when I see you.
Mladen Gogala
------_=_NextPart_001_01C25391.97FF00B0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4915.500" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=134442821-03092002><FONT face=Arial color=#0000ff size=2>It
looks like when option "ORDER" is used Oracle guarantees the generated values
will be in order since the "CACHE" option will be ignored by Oracle even if it
was requested.</FONT></SPAN></DIV>
<DIV><SPAN class=134442821-03092002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=134442821-03092002><FONT face=Arial color=#0000ff size=2>This
is in the parallel mode.</FONT></SPAN></DIV>
<DIV><SPAN class=134442821-03092002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=134442821-03092002><FONT face=Arial color=#0000ff size=2>Look
at note: <FONT color=#000000 size=3>Note:1031850.6</FONT></FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2><SPAN class=094075120-03092002>before the smaller one).</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=094075120-03092002>Please, o OPS godsand godesses, help me out and I'll sacrifice you a beer when I see you.</SPAN></FONT></DIV>
------_=_NextPart_001_01C25391.97FF00B0--
------=_NextPartTM-000-577f5aa6-faa1-40fd-8cd5-37f3dced9ed4--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Sep 03 2002 - 17:38:37 CDT
 |
 |