• 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 | 6 Comments |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

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 © 2020 SnapDBA.com