Re: Oracle-sequence and NOORDER
From: dombrooks <dombrooks_at_hotmail.com>
Date: Thu, 20 Sep 2012 03:50:02 -0700 (PDT)
Message-ID: <5a016bfd-d24a-4de4-a72d-eee7a98d96c5_at_googlegroups.com>
> Is it possible to create a test-case where they actually do come out-
> of-order?
If you use RAC and request sequence numbers on different nodes then yes - each node has its own cache. Received on Thu Sep 20 2012 - 05:50:02 CDT
Date: Thu, 20 Sep 2012 03:50:02 -0700 (PDT)
Message-ID: <5a016bfd-d24a-4de4-a72d-eee7a98d96c5_at_googlegroups.com>
> Is it possible to create a test-case where they actually do come out-
> of-order?
If you use RAC and request sequence numbers on different nodes then yes - each node has its own cache. Received on Thu Sep 20 2012 - 05:50:02 CDT