On Tue, Aug 21, 2001 at 01:53:07PM -0800, Aldi Barco wrote:
> Hi,
>
> My database generated so many archived log now, let say 20 archived log per
> minute. The application and the number of rows in the database is not too
> much different with few days ago.
How did you determine this to be true? The last time it happened to me
some developer had written the loop from hell and turned it loose.
Statspack report gives a list of the sql activity. sql_text from
v$sqlarea might be a good thing to look at. I can't, off the top of my
head link the sid to the query, but when all the real dbas wake up they
will quote it to you, sid from v$session linked to some hash. That
link of what id is running what sql seems to be missing from statspack,
think I'll try to add that in later.
===============================================================
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
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).
