sys_guid()

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Fri, 1 Oct 2021 10:28:26 +0100
Message-ID: <CAGtsp8m_HZT6av2rhjKyu5bQVcem8Ud-GApFFFPGsbLuhgDhFg_at_mail.gmail.com>

I put out a tweet yesterday (
https://twitter.com/JLOracle/status/1443302780266029061 ) about sys_guid() and the different pattern of results you could get depending on the platform you were running on. The most recent check I had done was 12.1.0.2, and I don't have access to anything other than OEL 7.9 at the moment to check more recent versions.

It would be nice if a few people could run the following query on their systems and report the results, along with O/S, for 19c to see if there are stll differences.

Here's my result from 19.11

SQL> select sys_guid() from all_tables where rownum <= 5;

SYS_GUID()

---

CD47CA7FBE987B90E0530100007FE7D5
CD47CA7FBE997B90E0530100007FE7D5
CD47CA7FBE9A7B90E0530100007FE7D5
CD47CA7FBE9B7B90E0530100007FE7D5
CD47CA7FBE9C7B90E0530100007FE7D5 5 rows selected.

Almost simultaneously from another session SYS_GUID()

---

CD47CB493173114BE0530100007FA8A8
CD47CB493174114BE0530100007FA8A8
CD47CB493175114BE0530100007FA8A8
CD47CB493176114BE0530100007FA8A8
CD47CB493177114BE0530100007FA8A8

This seems to have a sequential component tied to the session (possibly to the moment the session connected** rather than the session id). If you follow the links in the tweet you'll find that Oracle on Windows used to produce very random-looking leading values you reconnect once per session and run t

• If I reconnect once per session then the 7th digit of the guid increments by 1.

Regards
Jonathan Lewis

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 01 2021 - 11:28:26 CEST