Day Saving Time change and ASH data

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*

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