From Rajesh@ohitelecom.com Sun, 04 Nov 2001 06:26:13 -0800 From: Rajesh Dayal Date: Sun, 04 Nov 2001 06:26:13 -0800 Subject: Oracle Archiving insanely Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: Rajesh@ohitelecom.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).