From rafiq9857@hotmail.com Fri, 02 Feb 2001 11:54:53 -0800 From: "Mohammad Rafiq" Date: Fri, 02 Feb 2001 11:54:53 -0800 Subject: RE: V$log Status Message-ID: MIME-Version: 1.0 Content-Type: text/plain Then , definately requires changes in code. Please ask developers/owner of application code to inroduce some commit size or if parallel inserts are involved then reduce size of parallel degree. If any table is being created during batch process then use unrecoverable/nologging clause. One thing is sure that there are lot of dml generated by batch job. Regards Rafiq Reply-To: ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L Date: Fri, 02 Feb 2001 10:39:49 -0800 I tried by increasing the log size to 100M with 10 groups. Still I am facing the same problem. -----Original Message----- Sent: 02 February 2001 17:11 To: Multiple recipients of list ORACLE-L Check your alert log messages specially 'check point not completed' or requires archiving...If yes you have to increase size of your log files...10MB size looks small... Regards Rafiq Reply-To: ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L Date: Fri, 02 Feb 2001 04:25:37 -0800 Hi All, I am doing a batch update which updates around 100,000 rows. While this updating is in progress, the system slows down all in a sudden for few minutes before it continue to work normally. The archive log is enabled and I have 5 online groups with each 10 MB size. If I check the V$log while updation in progress, I find the status is in ACTIVE even after the archive file written for that log. This sequence continues until all the log files except current one in ACTIVE state. After couple of minutes all the ACTIVE status getting changed to INACTIVE. Any Idea what could be the reason for this? I got 8.1.6 undex solaris. TIA Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: raj.gopalan@netdecisions.co.uk 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: ListGuru@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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857@hotmail.com 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: ListGuru@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: raj.gopalan@netdecisions.co.uk 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: ListGuru@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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857@hotmail.com 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: ListGuru@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).