RE: Oracle Archiving insanely

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: root_at_fatcity.com [mailto:root_at_fatcity.com]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: Rajesh_at_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_at_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).>>> _________________________________________________________> 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: kaygopal_at_yahoo.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_at_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: James Morle
INET: James.Morle_at_scaleabilities.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_at_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).