Home » Server Options » RAC & Failsafe » RAC Sequence generation (Oracle 10g Rel2, Linux AS4)
RAC Sequence generation [message #357360] Wed, 05 November 2008 00:56 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello ,

In a RAC environment , what will be the sequence generation from one instance to the other instance . I mean if a user has created a sequence on node1 and if other user want to use the same sequence in node 2 , what will be the sequence generation .

And what will be SCN generation on 2 Node RAC . IS it going to be sequential or is it going to be different with respect to each instance.

Regards,
Raj
Re: RAC Sequence generation [message #357367 is a reply to message #357360] Wed, 05 November 2008 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If by sequence you mean SCN and not SQL sequence, yes each instance has its own SCN generation.

Regards
Michel
Re: RAC Sequence generation [message #357371 is a reply to message #357367] Wed, 05 November 2008 01:32 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thanks , but what if we are creating SQL sequence on one node and if both the nodes are using the same sequence in a RAC database .

Is it going to be different on each or the same number on both the nodes . I read that it's going to be different and also read that we can make the sequence generation orderly by using something called as ordered in oracle 10g .

Any help on this will be appreciatred .

Raj
Re: RAC Sequence generation [message #357377 is a reply to message #357371] Wed, 05 November 2008 01:55 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Each instance get a different set of numbers of the size of CACHE parameter and use it.
When there is no more number in this set, it asks for a new set.

Regards
Michel

Previous Topic: troubles with installing clusterware on windows 2000
Next Topic: Problem creating a instance
Goto Forum:
  


Current Time: Thu Mar 28 16:09:43 CDT 2024