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