Search This Blog

Sunday, July 22, 2018

query to find timezone (DST) version in oracle database 11.2.0.4?


Hello DBA's,

Use the below query to find daylight savings timezone version in the database. 

select * from v$timezone_file; 


Output :

SQL> select * from v$timezone_file;

timezlrg_18.dat              18


It shows that the database in version 18 and oracle home has been patched with DSTv18.


1 comment:

You cannot complete this task because one of the following events caused a loss of page data: A system failure has occurred "Front end is locked after 12.2 upgrade"

  If you have upgraded to Oracle E-Business Suite 12.2.10 Release Update Pack from Oracle E-Business Suite 12.2.6 Release Update Pack (or ea...