| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Archived logs
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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: ipal_at_hotmail.com 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). _________________________________________________________________ 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: rafiq9857_at_hotmail.com 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 Tue Aug 21 2001 - 16:11:53 CDT
 |
 |