Day Saving Time change and ASH data

  • From: Luis Santos <lsantos@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 8 Nov 2018 09:41:57 -0200

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*

Other related posts:

  • » Day Saving Time change and ASH data - Luis Santos