RE: databases on same server with different timezones...

What about setting the DB's individual time zones?
 

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

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Loughmiller, Greg
Sent: Thursday, July 28, 2005 12:29 PM
To: 'Oracle-L@xxxxxxxxxxxxx'
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). 

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......

 

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.

Other related posts: