Day Saving Time change and ASH data

[Luis Santos]

Hi everyone!

Here in our country we recently entered into DST period. Everything was
fine on the database. Our Unix server uses named TZ, which was correctly
programmed to reflect the time shift.

The SYSDATE and SYSTIMESTAMP are correct! And also CURRENT_TIMESTAMP and
LOCALTIMESTAMP, as our workstations are also on correct time. Our named TZ
is America/Sao_Paulo, which currently (DST on) means -02:00

* 1 select sysdate, SYSTIMESTAMP, CAST( LOCALTIMESTAMP AS TIMESTAMP
WITH TIME ZONE ) AT TIME ZONE 'America/Los_Angeles' AS TIMESTAMP*
* 2* from dual*
*SYSDATE SYSTIMESTAMP
TIMESTAMP*
*--------------------------------------
--------------------------------------
--------------------------------------------*
*08/11/18 08/11/18 09:38:28,634000 -02:00
08/11/18 03:38:28,634010 AMERICA/LOS_ANGELES*

But ASH data is been collect with the wrong time.

*[11g]> select LATEST_SAMPLE_ID , LATEST_SAMPLE_TIME from v$ash_info**;*
*LATEST_SAMPLE_ID LATEST_SAMPLE_TIME*
*---------------- --------------------** 113807442 08/11/18
08:38:34,20*

We are running 11.2.0.4 version on HP_UX Itanium 11.31.


*--*
*Att*


*Luis Santos*