Tuesday, May 6, 2008

Oracle versus SYS_GUID versus OS

GUID's are one of my favorite items. It must be something about a global uniqueness at my fingertips. But while working on the RACs using the OS of LYNX I noticed the GUIDs were not being generated randomly as I have come to expect. Noticed they are just incremented by one.

select SYS_GUID() FROM DUAL

RACS-LYNX 64 bit
----------------------
4c9381b29852307ae040190a82003040
4c9381b29853307ae040190a82003040
4c9381b29854307ae040190a82003040
4c9381b29855307ae040190a82003040
4c9381b29856307ae040190a82003040


Workflow Server-Windows (OWB)
-----------------------------------
ac600a534951477b9264a8bb0b3b09cb
73b347c1ed31402cb75be64506d44327
716533d75c4d433eb6ce7d74ca763754
ded34a7cfab64b2a976ad183d9725be4
fbabac678fa242949889fb9e9b4d24ca



I did run across this article to help explain the issue.
http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html

No comments: