Stored procedure - cursor not closed
resending the mail. Kindly ignore my prev mail with wrong subject. Hi All, I ve a stored proceure and with the following cursor defined. And after running the procedure, i see that No of open cursors incresing. I checked it querying v$open_cursor like this. ( SELECT sql_text from v$open_cursor). CURSOR all_rules (l_ticket_type_id NUMBER) IS SELECT rule_id , workflow_id FROM rule WHERE ticket_type_id = l_ticket_type_id AND ews_flag=1 AND active_flag=1; -- Cusror is processed as below.. FOR term_rec IN all_terms( p_rule_id ) LOOP -- do processing END LOOP; Since I m using CURSOR for stemennet its closed automaticaly. right?. But it doentnt seem closing as mentioned above ( when querried v$open_cursor). pls reply PS: Also in the stored procedure I use some SELECT statements, that too is shown when I query open_cursor as above. Do you know why no of open cursors increasing? Thanks in advance Joshy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SNP uses 60% of CPU on Windows2000 - please help
Hi All, I ve a stored proceure and with the following cursor defined. And after running the procedure, i see that No of open cursors incresing. I checked it querying v$open_cursor like this. ( SELECT sql_text from v$open_cursor). CURSOR all_rules (l_ticket_type_id NUMBER) IS SELECT rule_id , workflow_id FROM rule WHERE ticket_type_id = l_ticket_type_id AND ews_flag=1 AND active_flag=1; -- Cusror is processed as below.. FOR term_rec IN all_terms( p_rule_id ) LOOP -- do processing END LOOP; Since I m using CURSOR for stemennet its closed automaticaly. right?. But it doentnt seem closing as mentioned above ( when querried v$open_cursor). pls reply PS: Also in the stored procedure I use some SELECT statements, that too is shown when I query open_cursor as above. Do you know why no of open cursors increasing? Thanks in advance Joshy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Cursor : please help
Hi All, I ve a JSP application. Each time I query database ( oracle 9i) from the page, I see that the no.of cursors increments by one. I m accessing database using JDBC, I close resultset and statement objects after query. But I m not closing Connection object since I use a Connection Pool. Can anyone tell why the no,of cursors increasing each time ? Thanks in advance Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Oracle 9i, tomcat
Hi All, Can anyone help me. This is very urgent. I have a ticker application written in Java, that accesses oracle 9i database in Linux. It gets data from database in every 2 minutes. When as many as 10 ticker clients are accessing database together for 30 minutes, oracle eventually dies. Ticker gets data from database thru Tomcat, on examination I found that each time memory utilization for Oracle increases with database access. It starts with 5% mem utilizations and increases - in every 2 minutes - 6%, 7% etc, for each database access from clients. When it reaches some 30% oracle slows down and ticker apllication also slows down. Does anyone of you have a quick solution - Also why oracle not relasing memory after database access ? Thanks in Advance Joshy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Oracle 9i, tomcat
Hi Neyman, Thanks for your quick response. I use connection pool. Initially it makes 25 connection objects and put in the pool and they are reused. Not closed. But I close prep statements and resultset after using it, but to no avail. Any idea? Thanks Joshy -Original Message- Sent: Wednesday, July 31, 2002 10:04 PM To: Multiple recipients of list ORACLE-L Most probably, it's not Oracle, it's your application, that does not allow oracle to release memory. Are you closing your connections properly? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:33 AM Hi All, Can anyone help me. This is very urgent. I have a ticker application written in Java, that accesses oracle 9i database in Linux. It gets data from database in every 2 minutes. When as many as 10 ticker clients are accessing database together for 30 minutes, oracle eventually dies. Ticker gets data from database thru Tomcat, on examination I found that each time memory utilization for Oracle increases with database access. It starts with 5% mem utilizations and increases - in every 2 minutes - 6%, 7% etc, for each database access from clients. When it reaches some 30% oracle slows down and ticker apllication also slows down. Does anyone of you have a quick solution - Also why oracle not relasing memory after database access ? Thanks in Advance Joshy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).