Re: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR'

as each client connects the session nls_date format is changed to match the settings in the client's registry ( if windows type) or environment variables ( for others) - if there is no such setting and NO NLS_ type parameters are set on the client, the NLS_Date_Format from the init<sid>.ora file is used - if none are set anywhere the default is used ( the one you are seeing is the default, I believe)

"Yossi Galazan" <yossi.galazan_at_emblaze.com> wrote:

>
>I looked at v$session and v$sqlarea tables
>and find the text:
>"ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR'"
>The text repeated many times each time with different sid and with the
>status of inactive.
>Who is running this command? and why does it happand?
>Any help?
>Yossi Galazan
>yossi.galazan_at_embalze.com
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Sep 05 2001 - 09:41:58 CDT