Re: Why so many "alter session set nls_language=..." sql_texts?

donald.mccue_at_tinker.af.mil wrote:

>Hi! Why are there so many cursors with sql_text entries that look like
>this on my Oracle 8i system?:
>
>alter session set nls_language= 'AMERICAN' nls_territory= 'A ... on and
>on ...
>
>whenever I type the command -
>SQL> SELECT SQL_TEXT FROM V$OPEN_CURSOR;
>
>there are several dozen of the alter session sql_texts. There are less
>than 60 sessions going on at any one time.
>
>What can I do to shrink this number of alter session queries? Is it
>something in the way the sessions are being started?
>
>Thanks,
>
>Skeeter

Could be that the users have NLS_ parameters set in their registry and the registry setting will always override the init<sid>.ora ones.. Received on Thu Oct 13 2005 - 15:54:13 CDT