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

Home -> Community -> Usenet -> c.d.o.misc -> idle sessions from ADO.NET despite closing them?

idle sessions from ADO.NET despite closing them?

From: jobs <jobs_at_webdos.com>
Date: Fri, 16 Nov 2007 08:32:51 -0800 (PST)
Message-ID: <b5477c09-f6d0-484f-a68e-9d58b72e0cf7@b32g2000hsa.googlegroups.com>


I connect to Oracle and close the connection in my code every time. Dispite that sessions remain idle showing following:

ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS=
'.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR'
NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '-05:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '$' NLS_TIME_FORMAT=
'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM'
NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD- -RR HH.MI.SSXFF AM TZR' I'm not sure if related, but my connection string has this set to true:

Persist Security Info=True

The dba has set idle sessions to be killed after 10 minutes. And Ive set IIS to kill idle sessions after 10 minutes of inactivity.

However, I still occassionally hit the max number of processes in Oracle.

Thanks for any help or information. Received on Fri Nov 16 2007 - 10:32:51 CST

Original text of this message

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