On Mon, 8 Nov 2004 16:05:41 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > My DBA is having a fit because every connection from DBI/DBD Oracle is > issuing a ALTER SESSION SET TIME_ZONE='-04:00'; . She sees this as > unneccessary and a waste of resource. Is this really neccessary, and > is there a way to no do it?
Can she demonstrate that there is a significant performance hit? I'd have my doubts, but... Are you sure it is DBI/DBD::Oracle that's doing it and not the applications written using it? Is the time zone correct for programs running on your machine? Does the time zone vary depending on the TZ value set for the client program? If the time zone is correct and tracks the TZ environment variable, it is probably doing explicitly what might be done implicitly - and that may be as much for dealing with some retrograde version of OCI as because it is currently necessary. Have you looked for the ALTER SESSION statement in DBD::Oracle code? Have you tried omitting it? -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2003.04 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
