Re: ALTER SESSION implicit execution?

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Dec 2004 17:24:07 +0000

On Mon, 13 Dec 2004 17:11:37 -0000, Johnson, George <GJohnson@xxxxxxx> 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?
--
//www.freelists.org/webpage/oracle-l

Other related posts: