Re: Archived logs

From: Ray Stell <stellr_at_stell.cns.vt.edu>
Date: Wed, 22 Aug 2001 01:29:09 -0700
Message-ID: <F001.00373813.20010822012730@fatcity.com>

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 stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_stell.cns.vt.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).

Received on Wed Aug 22 2001 - 03:29:09 CDT