RE: ORDER -- was Re[2]: Sequences in OPS/RAC

ORDER isn't strictly necessary when all you want are unique numbers.

There are times when you cannot afford to lose CACHed values, as John Kanagaraj has pointed out
in Oracle Applications when generating Cheque numbers. Such sequences required a patch in
Oracle Apps 10.7 and 11 and/or creation with NOCACHE.

An application where you need ORDER is when you are inserting new rows and the sequence number
must match the insertion temporaly -- ie, function like a timestamp so that you can fetch the same
rows in the same sequence.

Hemant

At 09:44 AM 03-11-03 -0800, you wrote:
>Hi,
>
>I have RAC and I always use ORDER when I create SEQUENCE. The following
>information is from Oracle Manual:
>
>ORDER is necessary only to guarantee ordered generation if you are using
>Oracle with Real Application Clusters. If you are using exclusive mode,
>sequence numbers are always generated in order.
>
>Muqthar Ahmed
>
>-----Original Message-----
>Sent: Monday, November 03, 2003 12:04 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hello Hemant,
>
>Monday, November 3, 2003, 11:29:26 AM, you wrote:
>HKC> However, the Builder.Com article quite explicity asserts
>HKC> "Sequence generator numbers are guaranteed to be unique only for a
>single
>HKC> instance, which is unsuitable for use as a primary key in parallel or
>HKC> remote environments, where a sequence in each environment might generate
>HKC> the same number and result in conflicts
>
>Can you point us to the article? My guess is that the author
>is not familiar with Oracle, and is basing the above
>statement on his experience with some other database (DB2
>perhaps?). There is no problem with using sequence numbers
>in a RAC. No conflicts will occur. I've never heard of a
>problem in that regard.
>
>Best regards,
>
>Jonathan Gennick --- Brighten the corner where you are
>http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>
>Join the Oracle-article list and receive one
>article on Oracle technologies per month by
>email. To join, visit
>http://four.pairlist.net/mailman/listinfo/oracle-article,
>or send email to Oracle-article-request_at_gennick.com and
>include the word "subscribe" in either the subject or body.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jonathan Gennick
> INET: jonathan_at_gennick.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Muqthar Ahmed
> INET: Muqthar.Ahmed_at_decoratetoday.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).