So Many Redo

From: Emre <emre_at_emre.com>
Date: Thu, 25 Jan 2007 08:19:55 GMT
Message-ID: <Xns98C368AC39F74emreemrecom@68.142.88.120>

Hi All I saw some interesting things in v$log_history view as that THEREAD-SEQUNCE# FIRST_CHANGE FIRST_TIME SWITCH_CHANGE#

1 2860 1003068839 1/23/2007 4:52:38 PM 1003075595
1 2861 1003075595 1/23/2007 4:52:40 PM 1003082486
1 2862 1003082486 1/23/2007 4:52:48 PM 1003089304

My Oracle has 3 redolog and size is 50 mb and usual log switch time is 1 hour

I am wondering something about this output;

1- Output seems like system has fulled all redo log in 10 sec then if dbwn didnt write blocks those are in first redo then system has stoped and wait to write complete ?If it has happened how can I see this wait event about the past 2- To see which sql statement has caused to this event I wrote a query ;

select s.sql_text, a.sql_id
from v$sqlarea s
JOIN v$active_session_ history a ON (s.SQL_ID = a.SQL_ID) where TO_CHAR(a.sample_ time, 'DD/MM/YYYY HH24:MI') = '23/01/2007 16:52'

But there arent some sql_id entries those are in v$active_session_history in v$sqlare view.How can I see which sql statements in specified time ?

Best Regards... Received on Thu Jan 25 2007 - 02:19:55 CST