SnapDBA
  • Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Posts tagged "TZ"

Tag Archives: TZ

DBMS_SCHEDULER jobs running an hour late – DST/BST issues!

Posted on October 31, 2014 by Garth

This week one of our developers highlighted the fact that the DBMS_SCHEDULER on one of our 11.2.0.3 databases was running jobs an hour later than scheduled until just recently, when the clocks went back (26/10/2014) for British Summer Time (BST) …and now they’re running on-time again! I’d not seen this before, and at first I thought we

Read More…

Posted in Database, General | Tags: BST, DBMS_SCHEDULER, DST, EVALUATE_CALENDAR_STRING, TIMEZONE, TZ | 5 Comments |

Archived

Popular Posts

  • Using SQL Developer to connect to SQL Server databases
  • Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4
  • Creating an Oracle 11g Database using DBCA (non-ASM)
  • How to check which PSU is installed...if any
  • Cannot show requested dialog. (SqlMgmt) Property Owner is not available...

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
Copyright © 2018 SnapDBA.com
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OKPrivacy policy