Home » SQL & PL/SQL » SQL & PL/SQL » sequence with "NO ORDER" (Oracle 10g RAC)
sequence with "NO ORDER" [message #333166] Thu, 10 July 2008 11:56 Go to next message
naveen.ravindra@gmail.com
Messages: 2
Registered: July 2008
Junior Member
If we define sequence with "NO ORDER", other than sequences being potentially out of order, do you see any problems with doing this?
Re: sequence with "NO ORDER" [message #333168 is a reply to message #333166] Thu, 10 July 2008 12:13 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
The purpose of a sequence number is for a unique identifier, so it wouldn't matter if they are in order or not.

I also believe this is the default.
Re: sequence with "NO ORDER" [message #333186 is a reply to message #333166] Thu, 10 July 2008 14:50 Go to previous messageGo to next message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
Also the "no order" only matters when you have a cluster. If you have a single server, it makes no difference how you set it.
Re: sequence with "NO ORDER" [message #333319 is a reply to message #333166] Fri, 11 July 2008 04:16 Go to previous messageGo to next message
naveen.ravindra@gmail.com
Messages: 2
Registered: July 2008
Junior Member
Thanks for your response.

We see a performance impact when sequence# are selected in ORDER, and for every sequence #, it has to carry out GC (Global Caching) events to establish UNIQUENESS across 3 NODES using Global ENQ.

I wanted to know if there is any issue with "No Order" in clustered environment
Re: sequence with "NO ORDER" [message #333374 is a reply to message #333319] Fri, 11 July 2008 07:35 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only YOU know if there is any issue using NOORDER, it is YOUR application, Oracle put this clause for this RAC case.
Does your application supports sequence not in order?

Regards
Michel
Previous Topic: How to split a row having a delimited string as one of the columns into multiple rows
Next Topic: Creating a running counter?
Goto Forum:
  


Current Time: Sun Dec 04 02:30:03 CST 2016

Total time taken to generate the page: 0.07327 seconds