From oracle-l-bounce@freelists.org Thu Jul 28 14:03:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6SJ3n96005950 for ; Thu, 28 Jul 2005 14:03:49 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6SJ3jIP005938 for ; Thu, 28 Jul 2005 14:03:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 085911D7CEE; Thu, 28 Jul 2005 14:03:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01154-03; Thu, 28 Jul 2005 14:03:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CD961D8E89; Thu, 28 Jul 2005 14:03:38 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C593A6.BAF50CB5" Subject: RE: databases on same server with different timezones... Date: Thu, 28 Jul 2005 13:01:16 -0600 Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B8731C5@fiji.arraybp.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: databases on same server with different timezones... Thread-Index: AcWTomSFdGiOPaRfRmuoIZHRAvPzIgABEXgg From: "Reidy, Ron" To: , X-OriginalArrivalTime: 28 Jul 2005 19:01:15.0877 (UTC) FILETIME=[BADC2150:01C593A6] X-archive-position: 23013 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ron.Reidy@arraybiopharma.com Precedence: normal Reply-To: Ron.Reidy@arraybiopharma.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.2 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C593A6.BAF50CB5 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable What about setting the DB's individual time zones? =20 -----------------=20 Ron Reidy=20 Lead DBA=20 Array BioPharma, Inc.=20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of Loughmiller, Greg Sent: Thursday, July 28, 2005 12:29 PM To: 'Oracle-L@freelists.org' Subject: databases on same server with different timezones... Curious to see if anyone has a server, with multiple databases running = where each database has a different TZ requirement(Pacific, Mountain, = Central, and Eastern). And all databases on the server would use the = same Unix acct (aka oracle).=20 >From what I can gather, Oracle uses the "gettimeofday" call to satisfy = the request for a sysdate call. Thus, one would need to set the OS = TimeZone appropriately since the DB would obtain the date/time from the = OS... While I run thru the manual and metalink; I thought I would see if = anyone on the list has had this experience...... =20 Thanks Greg =20 This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. ------_=_NextPart_001_01C593A6.BAF50CB5 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
What=20 about setting the DB's individual time zones?
 

-----------------
Ron Reidy
Lead = DBA
Array BioPharma, Inc.

-----Original Message-----
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org]On Behalf Of Loughmiller,=20 Greg
Sent: Thursday, July 28, 2005 12:29 PM
To:=20 'Oracle-L@freelists.org'
Subject: databases on same server = with=20 different timezones...

Curious to see if anyone = has a=20 server, with multiple databases running where each database has a = different TZ=20 requirement(Pacific, Mountain, Central, and Eastern). And all databases = on the=20 server would use the same Unix acct (aka oracle). =

From what I can gather, = Oracle uses=20 the "gettimeofday" call to satisfy the request for a sysdate call. Thus, = one=20 would need to set the OS TimeZone appropriately since the DB would = obtain the=20 date/time from the OS... While I run thru the manual and metalink; I = thought I=20 would see if anyone on the list has had this=20 experience......

 

Thanks

Greg

 

This = electronic message transmission is a PRIVATE communication which = contains information
which may be confidential or privileged. The = information is intended to be for the use of the individual
or = entity named above. If you are not the intended recipient, please be = aware that any disclosure,
copying, distribution or use of the = contents of this information is prohibited. Please notify the sender =
of the delivery error by replying to this message, or notify us by = telephone (877-633-2436, ext. 0),
and then delete it from your = system.

------_=_NextPart_001_01C593A6.BAF50CB5-- -- http://www.freelists.org/webpage/oracle-l