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)
0