RAC Sequence generation [message #357360] |
Wed, 05 November 2008 00:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #357371 is a reply to message #357367] |
Wed, 05 November 2008 01:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|