| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Cursor mot closed problem
Dear all
I am using oracle 8.1.5 and JDBC Driver 8.1.5 the application is using Java with connection pooling.I am very new to oracle. Basically i have read alot of material regarding max cursor exceeded. Indeed i have close all the statement, resultset and use the finally ..whatever being suggested i have alrdy used it.
But when i query to see all the open cursor , there
are alot of open cursor and the result given show alot
of ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY'
and
ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN with the
status as INACTIVE plus all the sql statemnet that are
executed by the application
In the application itself we did not query this alter session.How come this sql statement existed.
How come although i have close all the statement,conn the cursor no still increasing and alot of open cursor still existed.
SQL QUERY:
select user_name, status, osuser, machine, a.sql_text
from v$session b,
v$open_cursor a
where a.sid = b.sid
RESULT :
USER_NAME STATUS OSUSER MACHINE SQL_TEXT MyUser INACTIVE jdbcuser jdbcclient
Please Help . Thank You
regards
JKean
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 02 2003 - 22:14:35 CST
 |
 |