Re: sys_guid()

Howard,

Thanks for the response.

Regards
Jonathan Lewis

On Fri, 1 Oct 2021 at 12:02, Howard Latham <howard.latham_at_gmail.com> wrote:

> Hi Jonathon
> RH EL 7.9
> Version 19.11.0.0.0
>
> SQL> select sys_guid() from all_tables where rownum <= 5;
>
> SYS_GUID()
> --------------------------------
> CD497B0D66C3B4A2E0536301020AFAD6
> CD497B0D66C4B4A2E0536301020AFAD6
> CD497B0D66C5B4A2E0536301020AFAD6
> CD497B0D66C6B4A2E0536301020AFAD6
> CD497B0D66C7B4A2E0536301020AFAD6
>
> SQL>
>
>
> Best Wishes
>
> Howard A. Latham
>
>
>
>
> On Fri, 1 Oct 2021 at 11:59, angelo <angelolistas_at_gmail.com> wrote:
>
>> 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()
>> --------------------------------
>> CD491BB3C35586D4E053283210AC3600
>> CD491BB3C35686D4E053283210AC3600
>> CD491BB3C35786D4E053283210AC3600
>> CD491BB3C35886D4E053283210AC3600
>> CD491BB3C35986D4E053283210AC3600
>>
>> obs: running the query again with / I got these same guids above
>>
>> then disconnect and reconnect another session
>>
>> Second execution (new session):
>>
>> SQL> select sys_guid() from all_tables where rownum <= 5;
>>
>> SYS_GUID()
>> --------------------------------
>> CD4924E586A095C0E053283210ACDD33
>> CD4924E586A195C0E053283210ACDD33
>> CD4924E586A295C0E053283210ACDD33
>> CD4924E586A395C0E053283210ACDD33
>> CD4924E586A495C0E053283210ACDD33
>>
>> SQL>
>>
>> guid has changed, similar yours
>>
>> 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