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).