Re: Oracle Archiving insanely

Try using logminer to see what is actually in the log files. It should point you to the statements creating the most redo. Also, you can check for active sessions.

Dennis

Rajesh Dayal 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: Dennis M. Heisler
  INET: dheisler_at_binghamton.edu

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