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: rjamya <rjamya_at_gmail.com>
Date: Mon, 13 Dec 2004 12:42:46 -0500
Message-ID: <9177895d041213094232100b8a@mail.gmail.com>


you are correct.

Raj

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

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

Original text of this message

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