Re: Oracle Archiving insanely

Take a look at session level stats for redo writes -
if nothing sticks out (ie they are all high) then
maybe look at tablespaces in backup mode

hth
connor

Rajesh Dayal <Rajesh_at_ohitelecom.com> wrote: > 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!?
Everything you'll ever need on one web page from News and Sport to Email and Music
Charts
http://uk.my.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.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).