Re: sys_guid()

Hello Jonathan,

I did.. 19.12 running on OCI (Oracle Cloud)

First execution

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

SYS_GUID()

I´ve never observed them before

regards ,

Angelo

On Fri, 1 Oct 2021 at 06:28, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> 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