Could it be a backlog in the online logs? The arch process(es) would still have to catch up, even if the job had long since finished. If you suspect it to be a current session, check the sesstats for 'redo size' for all the sessions. If one session is guilty of this, it will be immediately obvious.
James > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K > Gopalakrishnan > Sent: 04 November 2001 14:35 > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Archiving insanely > > > By any chance HOTBACKUP is turned on? > > > Best Regards, > K Gopalakrishnan > Bangalore, INDIA > + (91) 98451 78868 > > -----Original Message----- > Sent: Sunday, November 04, 2001 6:00 AM > To: Multiple recipients of list ORACLE-L > > H All, > > I am facing a very typical problem. One of my client's database > has suddenly started archiving > like mad. There is no change ( claimed by users) made to the database. I > checked Alert log, but could > not find anything. > Many times it generates up to 50 Mb of Archives per minute( > Earlier max upto 2-3 Mb/Min). I > did shutdown immediate, which took around 15 min ( acceptable), but > immediately after next startup > (with no user logged on), in next 3 minutes, it generated 100 Mb of > Archives ( how'z that possible) ??????? > How can I find out what is the thing that's causing such a > massive load on database. There is no > hotbackup going on. There is no Oracle scheduled job running. On OS side > also there is no scheduled job in > cron. Please suggest how to get down to the problem. How can I find out > which session/user is generating > so much of Redo? What possible preventive measures can I take??? > > We are on Oracle 8.1.6.0.0 on TRU64 Unix. > > Appreciate your suggestions and immediate help, > > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > 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). > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: K Gopalakrishnan > 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: James Morle 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).
