Hi gurus, i have this error in the replication process, when execute dbms_offline_og.end_load
any idea for this error... i search in the metalink and no found solution .. help me please .... @L�K ------------------------------------------------------------ Lic. Alexander Ord��ez Arroyo Caja Costarricense del Seguro Social Soporte T�cnico - Divisi�n de Inform�tica Telefono: 295-2004, San Jos�, Costa Rica [EMAIL PROTECTED] Icq# 30173325 ------------------------------------------------------------ The true is out there in WWW > -----Mensaje original----- > De: Ron Yount [SMTP:[EMAIL PROTECTED]] > Enviado el: Viernes 8 de Marzo de 2002 09:23 PM > Para: Multiple recipients of list ORACLE-L > Asunto: RE: cursor not closing > > In the for what it is worth department, I had similiar issues. After the > developers knocked themselves out looking for code that was not closing > the > cursor, I opened a tar: > > In a nutshell: yet another "feature" that cursors "even though closed by > the > session that opened them" remain available.... this is touted as a feature > since there may be a session later that could benefit from a previous > cursor... this behavior will continue until max_cursors is reached and > then > you are done...:-( > > You can remedy this situation with the _CLOSE_CACHED_OPEN_CURSORS=true > init > parameter. > > If you are interested in more detail... my tar number is: 1921166.995 > > HTH, > > -Ron- > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ji, Richard > > Sent: Friday, March 08, 2002 6:23 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: cursor not closing > > > > > > Identify all the codes where ResultSet, Statement are used and make sure > > they are closed after it's done. > > > > -----Original Message----- > > Sent: Friday, March 08, 2002 4:48 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, > > > > We have a Application that user JDBC thin client connecting to Oracle > > database. > > It seems like java code is opening the cursor , running some sql but not > > closing > > the cusrsor. > > Now the number of open_cursor reached 3568 . > > Is there any way we can close cursor from sqlplus. > > > > Thanks > > --Harvinder > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Harvinder Singh > > 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: Ji, Richard > > 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: Ron Yount > 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: Alexander Ordonez 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).
