Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ALTER SESSION implicit execution?

Re: ALTER SESSION implicit execution?

From: David Sharples <davidsharples_at_gmail.com>
Date: Mon, 13 Dec 2004 17:24:07 +0000
Message-ID: <be592d5504121309245698e5fd@mail.gmail.com>


On Mon, 13 Dec 2004 17:11:37 -0000, Johnson, George <GJohnson_at_gam.com> wrote:
>
> May sound like a silly question, but does Oracle implicitly execute
> ALTER SESSION statements for any connection into the database? My suspicion
> is it must do, to ensure local variables like time zones and languages are
> set correctly. We are currently going through our SQL and picking out
> candidates for tuning, we constantly come across this statement from almost
> every single application, whether home-grown or off the shelf, be it VB,
> ProC , C++, etc.

Dont have logon triggers on certain schemas do you?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 13 2004 - 11:19:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US