| RAC Sequence generation [message #357360] |
Wed, 05 November 2008 00:56  |
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  |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
