Database Administration (MOSC)

MOSC Banner

v$timezone different results

Hi,

Regarding to :

Linux 7.9

Oracle 19.16 EE, multitenant , RAC/4 nodes

I have noticed this behavior:

1- results from server (then change session to a pluggable)

SELECT property_name, property_value FROM database_properties
 WHERE property_name LIKE 'DST_%'
 ORDER BY property_name;

PROPERTY_NAME                 PROPERTY_VALUE
------------------------------ --------------------
DST_PRIMARY_TT_VERSION        32
DST_SECONDARY_TT_VERSION      0
DST_UPGRADE_STATE             NONE

SQL> select * from v$timezone_file ;

FILENAME               VERSION    CON_ID
-------------------- ---------- ----------
timezlrg_32.dat             32         0

SQL> select * from gv$timezone_file ;

FILENAME               VERSION    CON_ID
-------------------- ---------- ----------
timezlrg_32.dat             32         0
timezlrg_32.dat             32         0
timezlrg_32.dat             32         0
timezlrg_32.dat             32         0

2- results using sqlplus (connected to same pluggable)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center