Re: Daylight savings time, shutting down oracle

They may want to shut the databases down for other reasons so I don't know if you really want to question it if they insist. There may be batches that must be run off hours that won't handle the time change well. There maybe interfaces to other systems where some interfaces are changing their interface times and others are not. There may be a data integrity issue if date/time datatypes are important to the applications running.

The point is there could be many factors for their decision. You may want to trust the DBAs, their getting paid to make thoes decisions.

Graham Sutcliffe
MCSE
Senior Systems Architect
hybrid
DALnet #SQL

<kpacek_at_excite.com> wrote in message news:8tbs38$epq$1_at_nnrp1.deja.com...
> I'm sysadmin for a few boxes running oracle. Some are Solaris 8,
> oracle 8.0.1 others hp-ux 10.2, oracle 7.3.4 (I think). My DBA's are
> insisting that the db's be shut down between 1:30 -3:30 am Sun, during
> daylight savings time.
>
> Is there any point to this? Can anyone describe how oracle handles
> this or point me to a resource so I can bring the information to them
> to show that there is no reason for this? It seems to me, the box
> really runs GMT behind the scenes, where there is no such thing as
> daylight savings time.
>
> Thanks
> krp
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 27 2000 - 08:11:44 CDT