Check for code doing insert,delete,update etc in v$sqlarea..
you may run following script to check for active sessions resulting lot of
DML's
select
substr(username,1,10)"USER",process,sid,substr(sql_text,1,200),disk_reads,buffer_gets,rows_processed
from v$session,v$sqlarea
where sql_address=address and status = 'ACTIVE'
order by disk_reads desc
/
OR run
SELECT a.username AS username
, a.sid AS sid
, a.serial# AS ser#
, b.sql_text AS statement
FROM v$session a
, v$sqltext b
WHERE a.username IS NOT NULL
AND a.status = 'ACTIVE'
AND a.sql_address = b.address
AND a.sql_hash_value = b.hash_value
AND a.audsid != USERENV('sessionid')
ORDER BY sid
, ser#
, b.piece
/
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 21 Aug 2001 13:53:06 -0800
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.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived log
files ?
816 on Redhat Linux 6.2
Thanks for any clue.
Aldi
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Aldi Barco
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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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).
