the article from :http://m.blog.itpub.net/31393455/viewspace-2130875/
Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql) (文档 ID 1064487.1) In this Document Purpose Requirements Configuring Instructions Script Sample Output References Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.1.0.1 [Release 10.2 to 12.1] Information in this document applies to any platform. Purpose This script is intended to provide a user friendly guide to troubleshoot log file sync waits. The script will look at important parameters involved in log file sync waits, log file sync wait histogram data, and the script will look at some of the worst average log file sync times in the active session history data and AWR data and dump information to help determine why those times were the highest. The script will create a file called lfsdiag_.out in your local directory. See Note: 857576.1 for more information on troubleshooting 'log file sync' waits and see Note: 34592.1 for a definition of 'log file sync' and a list of known bugs. Requirements SQL*Plus - version 10.2.0.4 - 12.1 (can run on earlier versions but not tested and some queries may not work) Configuring Simply place the lfsdiag.sql script in a directory and grant execute permission to run. Instructions Launch sqlplus and run the script: sqlplus '/ as sysdba' SQL> @lfsdiag.sql Caution This sample code is provided for educational purposes only, and is not supported by Oracle Support. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Script Paste the script below into a file called lfsdiag.sql and give it execute permissions: -- NAME: LFSDIAG.SQL -- ------------------------------------------------------------------------ -- AUTHOR: Michael Polaski - Oracle Support Services -- ------------------------------------------------------------------------ -- PURPOSE: -- This script is intended to provide a user friendly guide to troubleshoot -- log file sync waits. The script will look at important parameters involved -- in log file sync waits, log file sync wait histogram data, and the script -- will look at the worst average log file sync times in the active session -- history data and AWR data and dump information to help determine why those -- times were the highest. The script will create a file called -- lfsdiag_.out in your local directory. set echo off set feedback off column timecol new_value timestamp column spool_extension new_value suffix select to_char(sysdate,'Mondd_hh24mi') timecol, '.out' spool_extension from sys.dual; column output new_value dbname select value || '_' output from v$parameter where name = 'db_name'; spool lfsdiag_&&dbname&×tamp&&suffix set trim on set trims on set lines 140 set pages 100 set verify off alter session set optimizer_features_enable = '10.2.0.4'; PROMPT LFSDIAG DATA FOR &&dbname&×tamp PROMPT Note: All timings are in milliseconds (1000 milliseconds = 1 second) PROMPT PROMPT IMPORTANT PARAMETERS RELATING TO LOG FILE SYNC WAITS: column name format a40 wra column value format a40 wra select inst_id, name, value from gv$parameter where ((value is not null and name like '%log_archive%') or name like '%commit%' or name like '%event=%' or name like '%lgwr%') and name not in (select name from gv$parameter where (name like '%log_archive_dest_state%' and value = 'enable') or name = 'log_archive_format') order by 1,2,3; PROMPT PROMPT ASH THRESHOLD... PROMPT PROMPT This will be the threshold in milliseconds for average log file sync PROMPT times. This will be used for the next queries to look for the worst PROMPT 'log file sync' minutes. Any minutes that have an average log file PROMPT sync time greater than the threshold will be analyzed further. column threshold_in_ms new_value threshold format 999999999.999 select min(threshold_in_ms) threshold_in_ms from (select inst_id, to_char(sample_time,'Mondd_hh24mi') minute, avg(time_waited)/1000 threshold_in_ms from gv$active_session_history where event = 'log file sync' group by inst_id,to_char(sample_time,'Mondd_hh24mi') order by 3 desc) where rownum <= 10; PROMPT PROMPT ASH WORST MINUTES FOR LOG FILE SYNC WAITS: PROMPT PROMPT APPROACH: These are the minutes where the avg log file sync time PROMPT was the highest (in milliseconds). column minute format a12 tru column event format a30 tru column program format a40 tru column total_wait_time format 999999999999.999 column avg_time_waited format 999999999999.999 select to_char(sample_time,'Mondd_hh24mi') minute, inst_id, event, sum(time_waited)/1000 TOTAL_WAIT_TIME , count(*) WAITS, avg(time_waited)/1000 AVG_TIME_WAITED from gv$active_session_history where event = 'log file sync' group by to_char(sample_time,'Mondd_hh24mi'), inst_id, event having avg(time_waited)/1000 > &&threshold order by 1,2; PROMPT PROMPT ASH LFS BACKGROUND PROCESS WAITS DURING WORST MINUTES: PROMPT PROMPT APPROACH: What is LGWR doing when 'log file sync' waits PROMPT are happening? LMS info may be relevent for broadcast PROMPT on commit and LNS data may be relevant for dataguard. PROMPT If more details are needed see the ASH DETAILS FOR WORST PROMPT MINUTES section at the bottom of the report. column inst format 999 column minute format a12 tru column event format a30 tru column program format a40 wra select to_char(sample_time,'Mondd_hh24mi') minute, inst_id inst, program, event, sum(time_waited)/1000 TOTAL_WAIT_TIME , count(*) WAITS, avg(time_waited)/1000 AVG_TIME_WAITED from gv$active_session_history where to_char(sample_time,'Mondd_hh24mi') in (select to_char(sample_time,'Mondd_hh24mi') from gv$active_session_history where event = 'log file sync' group by to_char(sample_time,'Mondd_hh24mi'), inst_id having avg(time_waited)/1000 > &&threshold and sum(time_waited)/1000 > 1) and (program like '%LGWR%' or program like '%LMS%' or program like '%LNS%' or event = 'log file sync') group by to_char(sample_time,'Mondd_hh24mi'), inst_id, program, event order by 1,2,3,5 desc, 4; PROMPT PROMPT HISTOGRAM DATA FOR LFS AND OTHER RELATED WAITS: PROMPT PROMPT APPROACH: Look at the wait distribution for log file sync waits PROMPT by looking at "wait_time_milli". Look at the high wait times then PROMPT see if you can correlate those with other related wait events. column event format a40 wra select inst_id, event, wait_time_milli, wait_count from gv$event_histogram where event in ('log file sync','gcs log flush sync', 'log file parallel write','wait for scn ack', 'log file switch completion','gc cr grant 2-way', 'gc buffer busy','gc current block 2-way') or event like '%LGWR%' or event like '%LNS%' order by 2 desc,1,3; PROMPT PROMPT ORDERED BY WAIT_TIME_MILLI select inst_id, event, wait_time_milli, wait_count from gv$event_histogram where event in ('log file sync','gcs log flush sync', 'log file parallel write','wait for scn ack', 'log file switch completion','gc cr grant 2-way', 'gc buffer busy','gc current block 2-way') or event like '%LGWR%' or event like '%LNS%' order by 3,1,2 desc; PROMPT PROMPT REDO WRITE STATS PROMPT PROMPT "redo write time" in centiseconds (100 per second) PROMPT 11.1: "redo write broadcast ack time" in centiseconds (100 per second) PROMPT 11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond) column value format 99999999999999999999 column milliseconds format 99999999999999.999 select v.version, ss.inst_id, ss.name, ss.value, decode(substr(version,1,4), '11.1',decode (name,'redo write time',value*10, 'redo write broadcast ack time',value*10), '11.2',decode (name,'redo write time',value*10, 'redo write broadcast ack time',value/1000), decode (name,'redo write time',value*10)) milliseconds from gv$sysstat ss, v$instance v where name like 'redo write%' and value > 0 order by 1,2,3; PROMPT PROMPT AWR WORST AVG LOG FILE SYNC SNAPS: PROMPT PROMPT APPROACH: These are the AWR snaps where the average 'log file sync' PROMPT times were the highest. column begin format a12 tru column end format a12 tru column name format a13 tru select dhs.snap_id, dhs.instance_number inst, to_char(dhs.begin_interval_time,'Mondd_hh24mi') BEGIN, to_char(dhs.end_interval_time,'Mondd_hh24mi') END, en.name, se.time_waited_micro/1000 total_wait_time, se.total_waits, se.time_waited_micro/1000 / se.total_waits avg_time_waited from dba_hist_snapshot dhs, wrh$_system_event se, v$event_name en where (dhs.snap_id = se.snap_id and dhs.instance_number = se.instance_number) and se.event_id = en.event_id and en.name = 'log file sync' and dhs.snap_id in (select snap_id from ( select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited from wrh$_system_event se, v$event_name en where se.event_id = en.event_id and en.name = 'log file sync' order by avg_time_waited desc) where rownum < 4) order by 1,2; PROMPT PROMPT AWR REDO WRITE STATS PROMPT PROMPT "redo write time" in centiseconds (100 per second) PROMPT 11.1: "redo write broadcast ack time" in centiseconds (100 per second) PROMPT 11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond) column stat_name format a30 tru select v.version, ss.snap_id, ss.instance_number inst, sn.stat_name, ss.value, decode(substr(version,1,4), '11.1',decode (stat_name,'redo write time',value*10, 'redo write broadcast ack time',value*10), '11.2',decode (stat_name,'redo write time',value*10, 'redo write broadcast ack time',value/1000), decode (stat_name,'redo write time',value*10)) milliseconds from wrh$_sysstat ss, wrh$_stat_name sn, v$instance v where ss.stat_id = sn.stat_id and sn.stat_name like 'redo write%' and ss.value > 0 and ss.snap_id in (select snap_id from ( select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited from wrh$_system_event se, v$event_name en where se.event_id = en.event_id and en.name = 'log file sync' order by avg_time_waited desc) where rownum < 4) order by 1,2,3; PROMPT PROMPT AWR LFS AND OTHER RELATED WAITS FOR WORST LFS AWRs: PROMPT PROMPT APPROACH: These are the AWR snaps where the average 'log file sync' PROMPT times were the highest. Look at related waits at those times. column name format a40 tru select se.snap_id, se.instance_number inst, en.name, se.total_waits, se.time_waited_micro/1000 total_wait_time, se.time_waited_micro/1000 / se.total_waits avg_time_waited from wrh$_system_event se, v$event_name en where se.event_id = en.event_id and (en.name in ('log file sync','gcs log flush sync', 'log file parallel write','wait for scn ack', 'log file switch completion','gc cr grant 2-way', 'gc buffer busy','gc current block 2-way') or en.name like '%LGWR%' or en.name like '%LNS%') and se.snap_id in (select snap_id from ( select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited from wrh$_system_event se, v$event_name en where se.event_id = en.event_id and en.name = 'log file sync' order by avg_time_waited desc) where rownum < 4) order by 1, 6 desc; PROMPT PROMPT AWR HISTOGRAM DATA FOR LFS AND OTHER RELATED WAITS FOR WORST LFS AWRs: PROMPT Note: This query won't work on 10.2 - ORA-942 PROMPT PROMPT APPROACH: Look at the wait distribution for log file sync waits PROMPT by looking at "wait_time_milli". Look at the high wait times then PROMPT see if you can correlate those with other related wait events. select eh.snap_id, eh.instance_number inst, en.name, eh.wait_time_milli, eh.wait_count from wrh$_event_histogram eh, v$event_name en where eh.event_id = en.event_id and (en.name in ('log file sync','gcs log flush sync', 'log file parallel write','wait for scn ack', 'log file switch completion','gc cr grant 2-way', 'gc buffer busy','gc current block 2-way') or en.name like '%LGWR%' or en.name like '%LNS%') and snap_id in (select snap_id from ( select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited from wrh$_system_event se, v$event_name en where se.event_id = en.event_id and en.name = 'log file sync' order by avg_time_waited desc) where rownum < 4) order by 1,3 desc,2,4; PROMPT PROMPT ORDERED BY WAIT_TIME_MILLI PROMPT Note: This query won't work on 10.2 - ORA-942 select eh.snap_id, eh.instance_number inst, en.name, eh.wait_time_milli, eh.wait_count from wrh$_event_histogram eh, v$event_name en where eh.event_id = en.event_id and (en.name in ('log file sync','gcs log flush sync', 'log file parallel write','wait for scn ack', 'log file switch completion','gc cr grant 2-way', 'gc buffer busy','gc current block 2-way') or en.name like '%LGWR%' or en.name like '%LNS%') and snap_id in (select snap_id from ( select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited from wrh$_system_event se, v$event_name en where se.event_id = en.event_id and en.name = 'log file sync' order by avg_time_waited desc) where rownum < 4) order by 1,4,2,3 desc; PROMPT PROMPT ASH DETAILS FOR WORST MINUTES: PROMPT PROMPT APPROACH: If you cannot determine the problem from the data PROMPT above, you may need to look at the details of what each session PROMPT is doing during each 'bad' snap. Most likely you will want to PROMPT note the times of the high log file sync waits, look at what PROMPT LGWR is doing at those times, and go from there... column program format a45 wra column sample_time format a25 tru column event format a30 tru column time_waited format 999999.999 column p1 format a40 tru column p2 format a40 tru column p3 format a40 tru select sample_time, inst_id inst, session_id, program, event, time_waited/1000 TIME_WAITED, p1text||': '||p1 p1,p2text||': '||p2 p2,p3text||': '||p3 p3 from gv$active_session_history where to_char(sample_time,'Mondd_hh24mi') in (select to_char(sample_time,'Mondd_hh24mi') from gv$active_session_history where event = 'log file sync' group by to_char(sample_time,'Mondd_hh24mi'), inst_id having avg(time_waited)/1000 > &&threshold) and time_waited > 0.5 order by 1,2,3,4,5; select to_char(sysdate,'Mondd hh24:mi:ss') TIME from dual; spool off PROMPT PROMPT OUTPUT FILE IS: lfsdiag_&&dbname&×tamp&&suffix PROMPT Sample Output LFSDIAG DATA FOR DBM_Oct10_1307 Note: All timings are in milliseconds (1000 milliseconds = 1 second) IMPORTANT PARAMETERS RELATING TO LOG FILE SYNC WAITS: INST_ID NAME VALUE ---------- ---------------------------------------- ---------------------------------------- 1 commit_logging 1 commit_point_strength 1 1 commit_wait 1 commit_write 1 log_archive_local_first TRUE 1 log_archive_max_processes 4 1 log_archive_min_succeed_dest 1 1 log_archive_start FALSE 1 log_archive_trace 0 2 commit_logging 2 commit_point_strength 1 2 commit_wait 2 commit_write 2 log_archive_local_first TRUE 2 log_archive_max_processes 4 2 log_archive_min_succeed_dest 1 2 log_archive_start FALSE 2 log_archive_trace 0 ASH THRESHOLD... This will be the threshold in milliseconds for average log file sync times. This will be used for the next queries to look for the worst 'log file sync' minutes. Any minutes that have an average log file sync time greater than the threshold will be analyzed further. THRESHOLD_IN_MS --------------- .000 ASH WORST MINUTES FOR LOG FILE SYNC WAITS: APPROACH: These are the minutes where the avg log file sync time was the highest (in milliseconds). MINUTE INST_ID EVENT TOTAL_WAIT_TIME WAITS AVG_TIME_WAITED ------------ ---------- ------------------------------ ----------------- ---------- ----------------- Oct01_0111 2 log file sync .807 1 .807 Oct02_0600 2 log file sync 4.308 1 4.308 Oct09_0043 2 log file sync 999.805 1 999.805 ASH LFS BACKGROUND PROCESS WAITS DURING WORST MINUTES: APPROACH: What is LGWR doing when 'log file sync' waits are happening? LMS info may be relevent for broadcast on commit and LNS data may be relevant for dataguard. If more details are needed see the ASH DETAILS FOR WORST MINUTES section at the bottom of the report. MINUTE INST PROGRAM EVENT TOTAL_WAIT_TIME WAITS AVG_TIME_WAITED ------------ ---- ---------------------------------------- ------------------------------ ----------------- ---------- ----------------- Oct02_0600 2 oracle@racnode1.us.oracle.com (LGWR) log file parallel write 4.088 1 4.088 Oct02_0600 2 oracle@racnode1.us.oracle.com (M000) log file sync 4.308 1 4.308 Oct09_0043 2 oracle@racnode1.us.oracle.com (LGWR) log file parallel write 1000.738 1 1000.738 Oct09_0043 2 sqlplus@racnode1.us.oracle.com (TNS V1- log file sync 999.805 1 999.805 V3) HISTOGRAM DATA FOR LFS AND OTHER RELATED WAITS: APPROACH: Look at the wait distribution for log file sync waits by looking at "wait_time_milli". Look at the high wait times then see if you can correlate those with other related wait events. INST_ID EVENT WAIT_TIME_MILLI WAIT_COUNT ---------- ---------------------------------------- --------------- ---------- 2 wait for scn ack 1 0 2 wait for scn ack 2 0 2 wait for scn ack 4 0 2 wait for scn ack 8 1 1 log file sync 1 10247 1 log file sync 2 435 1 log file sync 4 122 1 log file sync 8 33 1 log file sync 16 4 1 log file sync 32 2 1 log file sync 64 2 1 log file sync 128 1 1 log file sync 256 1 1 log file sync 512 0 1 log file sync 1024 5 1 log file sync 2048 0 1 log file sync 4096 0 1 log file sync 8192 1 2 log file sync 1 7821 2 log file sync 2 492 2 log file sync 4 173 2 log file sync 8 120 2 log file sync 16 22 2 log file sync 32 16 2 log file sync 64 3 2 log file sync 128 3 2 log file sync 256 0 2 log file sync 512 0 2 log file sync 1024 7 2 log file sync 2048 0 2 log file sync 4096 1 1 log file switch completion 1 0 1 log file switch completion 2 0 1 log file switch completion 4 0 1 log file switch completion 8 0 1 log file switch completion 16 0 1 log file switch completion 32 0 1 log file switch completion 64 0 1 log file switch completion 128 1 2 log file switch completion 1 0 2 log file switch completion 2 0 2 log file switch completion 4 0 2 log file switch completion 8 0 2 log file switch completion 16 1 2 log file switch completion 32 0 2 log file switch completion 64 1 2 log file switch completion 128 1 1 log file parallel write 1 273379 1 log file parallel write 2 2812 1 log file parallel write 4 2161 1 log file parallel write 8 8603 1 log file parallel write 16 2822 1 log file parallel write 32 484 1 log file parallel write 64 212 1 log file parallel write 128 50 1 log file parallel write 256 10 1 log file parallel write 512 0 1 log file parallel write 1024 7 1 log file parallel write 2048 0 1 log file parallel write 4096 0 1 log file parallel write 8192 1 2 log file parallel write 1 890229 2 log file parallel write 2 4392 2 log file parallel write 4 2274 2 log file parallel write 8 8688 2 log file parallel write 16 3649 2 log file parallel write 32 704 2 log file parallel write 64 235 2 log file parallel write 128 51 2 log file parallel write 256 3 2 log file parallel write 512 2 2 log file parallel write 1024 14 2 log file parallel write 2048 1 2 log file parallel write 4096 0 2 log file parallel write 8192 1 2 log file parallel write 16384 0 2 log file parallel write 32768 0 2 log file parallel write 65536 0 2 log file parallel write 131072 2 2 log file parallel write 262144 1 1 gcs log flush sync 1 34429 1 gcs log flush sync 2 1378 1 gcs log flush sync 4 640 1 gcs log flush sync 8 254 1 gcs log flush sync 16 953 2 gcs log flush sync 1 106292 2 gcs log flush sync 2 3693 2 gcs log flush sync 4 401 2 gcs log flush sync 8 289 2 gcs log flush sync 16 1825 1 gc current block 2-way 1 183987 1 gc current block 2-way 2 53 1 gc current block 2-way 4 9 1 gc current block 2-way 8 6 1 gc current block 2-way 16 8 1 gc current block 2-way 32 8 1 gc current block 2-way 64 0 INST_ID EVENT WAIT_TIME_MILLI WAIT_COUNT ---------- ---------------------------------------- --------------- ---------- 1 gc current block 2-way 128 0 1 gc current block 2-way 256 0 1 gc current block 2-way 512 0 1 gc current block 2-way 1024 0 1 gc current block 2-way 2048 0 1 gc current block 2-way 4096 0 1 gc current block 2-way 8192 0 1 gc current block 2-way 16384 0 1 gc current block 2-way 32768 0 1 gc current block 2-way 65536 0 1 gc current block 2-way 131072 0 1 gc current block 2-way 262144 0 1 gc current block 2-way 524288 0 1 gc current block 2-way 1048576 1 2 gc current block 2-way 1 267712 2 gc current block 2-way 2 59 2 gc current block 2-way 4 20 2 gc current block 2-way 8 18 2 gc current block 2-way 16 33 2 gc current block 2-way 32 75 2 gc current block 2-way 64 16 2 gc current block 2-way 128 4 2 gc current block 2-way 256 1 1 gc cr grant 2-way 1 24433 1 gc cr grant 2-way 2 14 1 gc cr grant 2-way 4 4 1 gc cr grant 2-way 8 5 1 gc cr grant 2-way 16 2 2 gc cr grant 2-way 1 18443 2 gc cr grant 2-way 2 61 2 gc cr grant 2-way 4 34 2 gc cr grant 2-way 8 17 2 gc cr grant 2-way 16 16 2 gc cr grant 2-way 32 23 2 gc cr grant 2-way 64 16 2 gc cr grant 2-way 128 11 1 LGWR wait for redo copy 1 40880 1 LGWR wait for redo copy 2 7 1 LGWR wait for redo copy 4 1 1 LGWR wait for redo copy 8 1 1 LGWR wait for redo copy 16 2 1 LGWR wait for redo copy 32 0 1 LGWR wait for redo copy 64 1 2 LGWR wait for redo copy 1 78781 2 LGWR wait for redo copy 2 5 2 LGWR wait for redo copy 4 6 2 LGWR wait for redo copy 8 5 2 LGWR wait for redo copy 16 3 2 LGWR wait for redo copy 32 10 2 LGWR wait for redo copy 64 7 2 LGWR wait for redo copy 128 1 ORDERED BY WAIT_TIME_MILLI INST_ID EVENT WAIT_TIME_MILLI WAIT_COUNT ---------- ---------------------------------------- --------------- ---------- 1 log file sync 1 10247 1 log file switch completion 1 0 1 log file parallel write 1 273379 1 gcs log flush sync 1 34429 1 gc current block 2-way 1 183987 1 gc cr grant 2-way 1 24433 1 LGWR wait for redo copy 1 40880 2 wait for scn ack 1 0 2 log file sync 1 7821 2 log file switch completion 1 0 2 log file parallel write 1 890229 2 gcs log flush sync 1 106292 2 gc current block 2-way 1 267712 2 gc cr grant 2-way 1 18443 2 LGWR wait for redo copy 1 78781 1 log file sync 2 435 1 log file switch completion 2 0 1 log file parallel write 2 2812 1 gcs log flush sync 2 1378 1 gc current block 2-way 2 53 1 gc cr grant 2-way 2 14 1 LGWR wait for redo copy 2 7 2 wait for scn ack 2 0 2 log file sync 2 492 2 log file switch completion 2 0 2 log file parallel write 2 4392 2 gcs log flush sync 2 3693 2 gc current block 2-way 2 59 2 gc cr grant 2-way 2 61 2 LGWR wait for redo copy 2 5 1 log file sync 4 122 1 log file switch completion 4 0 1 log file parallel write 4 2161 1 gcs log flush sync 4 640 1 gc current block 2-way 4 9 1 gc cr grant 2-way 4 4 1 LGWR wait for redo copy 4 1 2 wait for scn ack 4 0 2 log file sync 4 173 2 log file switch completion 4 0 2 log file parallel write 4 2274 2 gcs log flush sync 4 401 2 gc current block 2-way 4 20 2 gc cr grant 2-way 4 34 2 LGWR wait for redo copy 4 6 1 log file sync 8 33 1 log file switch completion 8 0 1 log file parallel write 8 8603 1 gcs log flush sync 8 254 1 gc current block 2-way 8 6 1 gc cr grant 2-way 8 5 1 LGWR wait for redo copy 8 1 2 wait for scn ack 8 1 2 log file sync 8 120 2 log file switch completion 8 0 2 log file parallel write 8 8688 2 gcs log flush sync 8 289 2 gc current block 2-way 8 18 2 gc cr grant 2-way 8 17 2 LGWR wait for redo copy 8 5 1 log file sync 16 4 1 log file switch completion 16 0 1 log file parallel write 16 2822 1 gcs log flush sync 16 953 1 gc current block 2-way 16 8 1 gc cr grant 2-way 16 2 1 LGWR wait for redo copy 16 2 2 log file sync 16 22 2 log file switch completion 16 1 2 log file parallel write 16 3649 2 gcs log flush sync 16 1825 2 gc current block 2-way 16 33 2 gc cr grant 2-way 16 16 2 LGWR wait for redo copy 16 3 1 log file sync 32 2 1 log file switch completion 32 0 1 log file parallel write 32 484 1 gc current block 2-way 32 8 1 LGWR wait for redo copy 32 0 2 log file sync 32 16 2 log file switch completion 32 0 2 log file parallel write 32 704 2 gc current block 2-way 32 75 2 gc cr grant 2-way 32 23 2 LGWR wait for redo copy 32 10 1 log file sync 64 2 1 log file switch completion 64 0 1 log file parallel write 64 212 1 gc current block 2-way 64 0 1 LGWR wait for redo copy 64 1 2 log file sync 64 3 2 log file switch completion 64 1 2 log file parallel write 64 235 2 gc current block 2-way 64 16 2 gc cr grant 2-way 64 16 2 LGWR wait for redo copy 64 7 1 log file sync 128 1 INST_ID EVENT WAIT_TIME_MILLI WAIT_COUNT ---------- ---------------------------------------- --------------- ---------- 1 log file switch completion 128 1 1 log file parallel write 128 50 1 gc current block 2-way 128 0 2 log file sync 128 3 2 log file switch completion 128 1 2 log file parallel write 128 51 2 gc current block 2-way 128 4 2 gc cr grant 2-way 128 11 2 LGWR wait for redo copy 128 1 1 log file sync 256 1 1 log file parallel write 256 10 1 gc current block 2-way 256 0 2 log file sync 256 0 2 log file parallel write 256 3 2 gc current block 2-way 256 1 1 log file sync 512 0 1 log file parallel write 512 0 1 gc current block 2-way 512 0 2 log file sync 512 0 2 log file parallel write 512 2 1 log file sync 1024 5 1 log file parallel write 1024 7 1 gc current block 2-way 1024 0 2 log file sync 1024 7 2 log file parallel write 1024 14 1 log file sync 2048 0 1 log file parallel write 2048 0 1 gc current block 2-way 2048 0 2 log file sync 2048 0 2 log file parallel write 2048 1 1 log file sync 4096 0 1 log file parallel write 4096 0 1 gc current block 2-way 4096 0 2 log file sync 4096 1 2 log file parallel write 4096 0 1 log file sync 8192 1 1 log file parallel write 8192 1 1 gc current block 2-way 8192 0 2 log file parallel write 8192 1 1 gc current block 2-way 16384 0 2 log file parallel write 16384 0 1 gc current block 2-way 32768 0 2 log file parallel write 32768 0 1 gc current block 2-way 65536 0 2 log file parallel write 65536 0 1 gc current block 2-way 131072 0 2 log file parallel write 131072 2 1 gc current block 2-way 262144 0 2 log file parallel write 262144 1 1 gc current block 2-way 524288 0 1 gc current block 2-way 1048576 1 REDO WRITE STATS "redo write time" in centiseconds (100 per second) 11.1: "redo write broadcast ack time" in centiseconds (100 per second) 11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond) VERSION INST_ID NAME VALUE MILLISECONDS ----------------- ---------- ---------------------------------------- --------------------- ------------------- 11.2.0.3.0 1 redo write broadcast ack count 676 11.2.0.3.0 1 redo write broadcast ack time 144093133 144093.133 11.2.0.3.0 1 redo write time 22105 221050.000 11.2.0.3.0 1 redo writes 290541 11.2.0.3.0 2 redo write broadcast ack count 1000 11.2.0.3.0 2 redo write broadcast ack time 3519883 3519.883 11.2.0.3.0 2 redo write time 93028 930280.000 11.2.0.3.0 2 redo writes 910246 AWR WORST AVG LOG FILE SYNC SNAPS: APPROACH: These are the AWR snaps where the average 'log file sync' times were the highest. SNAP_ID INST BEGIN END NAME TOTAL_WAIT_TIME TOTAL_WAITS AVG_TIME_WAITED ---------- ---- ------------ ------------ ------------- ----------------- ----------- ----------------- 12002 1 Jun24_1715 Jun24_1730 log file sync 44087.518 672 65.606 12002 2 Jun24_1715 Jun24_1730 log file sync 988001.648 414752 2.382 12002 3 Jun24_1715 Jun24_1730 log file sync 3726.670 1349 2.763 12002 4 Jun24_1715 Jun24_1730 log file sync 4747362.294 1448060 3.278 12003 1 Jun24_1730 Jun24_1745 log file sync 44140.364 710 62.170 12003 2 Jun24_1730 Jun24_1745 log file sync 988806.288 414787 2.384 12003 3 Jun24_1730 Jun24_1745 log file sync 4200.097 1658 2.533 12003 4 Jun24_1730 Jun24_1745 log file sync 4747647.013 1448304 3.278 12004 1 Jun24_1745 Jun24_1800 log file sync 44490.880 783 56.821 12004 2 Jun24_1745 Jun24_1800 log file sync 988883.165 414883 2.384 12004 3 Jun24_1745 Jun24_1800 log file sync 4724.043 2057 2.297 12004 4 Jun24_1745 Jun24_1800 log file sync 4747733.174 1448434 3.278 AWR REDO WRITE STATS "redo write time" in centiseconds (100 per second) 11.1: "redo write broadcast ack time" in centiseconds (100 per second) 11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond) VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS ----------------- ---------- ---- ------------------------------ --------------------- ------------------- 11.2.0.3.0 12002 1 redo write broadcast ack time 617076 617.076 11.2.0.3.0 12002 1 redo write broadcast ack time 617076 617.076 11.2.0.3.0 12002 1 redo write time 3189 31890.000 11.2.0.3.0 12002 1 redo write time 3189 31890.000 11.2.0.3.0 12002 1 redo write time 3189 31890.000 11.2.0.3.0 12002 1 redo write broadcast ack time 617076 617.076 11.2.0.3.0 12002 1 redo write broadcast ack count 4820 11.2.0.3.0 12002 1 redo write broadcast ack count 4820 11.2.0.3.0 12002 1 redo writes 8802 11.2.0.3.0 12002 1 redo writes 8802 11.2.0.3.0 12002 1 redo writes 8802 11.2.0.3.0 12002 1 redo write broadcast ack count 4820 11.2.0.3.0 12002 2 redo write broadcast lgwr post 10 11.2.0.3.0 12002 2 redo write broadcast lgwr post 10 11.2.0.3.0 12002 2 redo write time 305710 3057100.000 11.2.0.3.0 12002 2 redo write time 305710 3057100.000 11.2.0.3.0 12002 2 redo write time 305710 3057100.000 11.2.0.3.0 12002 2 redo write broadcast ack count 758556 11.2.0.3.0 12002 2 redo write broadcast ack count 758556 11.2.0.3.0 12002 2 redo write broadcast ack count 758556 11.2.0.3.0 12002 2 redo writes 1415207 11.2.0.3.0 12002 2 redo writes 1415207 11.2.0.3.0 12002 2 redo writes 1415207 11.2.0.3.0 12002 2 redo write broadcast ack time 716928320 716928.320 11.2.0.3.0 12002 2 redo write broadcast ack time 716928320 716928.320 11.2.0.3.0 12002 2 redo write broadcast ack time 716928320 716928.320 11.2.0.3.0 12002 2 redo write broadcast lgwr post 10 11.2.0.3.0 12002 3 redo write broadcast ack time 516862 516.862 11.2.0.3.0 12002 3 redo write broadcast ack time 516862 516.862 11.2.0.3.0 12002 3 redo write time 1391 13910.000 11.2.0.3.0 12002 3 redo write time 1391 13910.000 11.2.0.3.0 12002 3 redo write time 1391 13910.000 11.2.0.3.0 12002 3 redo write broadcast ack time 516862 516.862 11.2.0.3.0 12002 3 redo write broadcast ack count 5503 11.2.0.3.0 12002 3 redo write broadcast ack count 5503 11.2.0.3.0 12002 3 redo writes 7723 11.2.0.3.0 12002 3 redo writes 7723 11.2.0.3.0 12002 3 redo writes 7723 11.2.0.3.0 12002 3 redo write broadcast ack count 5503 11.2.0.3.0 12002 4 redo write broadcast lgwr post 91 11.2.0.3.0 12002 4 redo write broadcast lgwr post 91 11.2.0.3.0 12002 4 redo write time 1903590 19035900.000 11.2.0.3.0 12002 4 redo write time 1903590 19035900.000 11.2.0.3.0 12002 4 redo write time 1903590 19035900.000 11.2.0.3.0 12002 4 redo write broadcast ack count 4069195 11.2.0.3.0 12002 4 redo write broadcast ack count 4069195 11.2.0.3.0 12002 4 redo write broadcast ack count 4069195 11.2.0.3.0 12002 4 redo writes 6554487 11.2.0.3.0 12002 4 redo writes 6554487 11.2.0.3.0 12002 4 redo writes 6554487 11.2.0.3.0 12002 4 redo write broadcast ack time 2473935096 2473935.096 11.2.0.3.0 12002 4 redo write broadcast lgwr post 91 11.2.0.3.0 12002 4 redo write broadcast ack time 2473935096 2473935.096 11.2.0.3.0 12002 4 redo write broadcast ack time 2473935096 2473935.096 11.2.0.3.0 12003 1 redo write broadcast ack time 752987 752.987 11.2.0.3.0 12003 1 redo write broadcast ack time 752987 752.987 11.2.0.3.0 12003 1 redo write broadcast ack time 752987 752.987 11.2.0.3.0 12003 1 redo writes 12676 11.2.0.3.0 12003 1 redo writes 12676 11.2.0.3.0 12003 1 redo write time 4022 40220.000 11.2.0.3.0 12003 1 redo write broadcast ack count 6248 11.2.0.3.0 12003 1 redo write broadcast ack count 6248 11.2.0.3.0 12003 1 redo write broadcast ack count 6248 11.2.0.3.0 12003 1 redo write time 4022 40220.000 11.2.0.3.0 12003 1 redo write time 4022 40220.000 11.2.0.3.0 12003 1 redo writes 12676 11.2.0.3.0 12003 2 redo write broadcast ack time 717871855 717871.855 11.2.0.3.0 12003 2 redo write broadcast ack time 717871855 717871.855 11.2.0.3.0 12003 2 redo write broadcast ack time 717871855 717871.855 11.2.0.3.0 12003 2 redo writes 1427035 11.2.0.3.0 12003 2 redo writes 1427035 11.2.0.3.0 12003 2 redo writes 1427035 11.2.0.3.0 12003 2 redo write broadcast ack count 768504 11.2.0.3.0 12003 2 redo write broadcast ack count 768504 11.2.0.3.0 12003 2 redo write broadcast ack count 768504 11.2.0.3.0 12003 2 redo write time 306911 3069110.000 11.2.0.3.0 12003 2 redo write time 306911 3069110.000 11.2.0.3.0 12003 2 redo write time 306911 3069110.000 11.2.0.3.0 12003 2 redo write broadcast lgwr post 10 11.2.0.3.0 12003 2 redo write broadcast lgwr post 10 11.2.0.3.0 12003 2 redo write broadcast lgwr post 10 11.2.0.3.0 12003 3 redo write broadcast ack time 736708 736.708 11.2.0.3.0 12003 3 redo write broadcast ack time 736708 736.708 11.2.0.3.0 12003 3 redo write time 1959 19590.000 11.2.0.3.0 12003 3 redo write time 1959 19590.000 11.2.0.3.0 12003 3 redo write time 1959 19590.000 11.2.0.3.0 12003 3 redo write broadcast ack time 736708 736.708 11.2.0.3.0 12003 3 redo write broadcast ack count 7894 11.2.0.3.0 12003 3 redo write broadcast ack count 7894 11.2.0.3.0 12003 3 redo writes 12275 11.2.0.3.0 12003 3 redo writes 12275 11.2.0.3.0 12003 3 redo writes 12275 11.2.0.3.0 12003 3 redo write broadcast ack count 7894 11.2.0.3.0 12003 4 redo write broadcast lgwr post 91 11.2.0.3.0 12003 4 redo write broadcast lgwr post 91 11.2.0.3.0 12003 4 redo write time 1903888 19038880.000 11.2.0.3.0 12003 4 redo write time 1903888 19038880.000 VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS ----------------- ---------- ---- ------------------------------ --------------------- ------------------- 11.2.0.3.0 12003 4 redo write time 1903888 19038880.000 11.2.0.3.0 12003 4 redo write broadcast ack count 4070420 11.2.0.3.0 12003 4 redo write broadcast ack count 4070420 11.2.0.3.0 12003 4 redo write broadcast ack count 4070420 11.2.0.3.0 12003 4 redo writes 6558259 11.2.0.3.0 12003 4 redo writes 6558259 11.2.0.3.0 12003 4 redo writes 6558259 11.2.0.3.0 12003 4 redo write broadcast ack time 2474064348 2474064.348 11.2.0.3.0 12003 4 redo write broadcast lgwr post 91 11.2.0.3.0 12003 4 redo write broadcast ack time 2474064348 2474064.348 11.2.0.3.0 12003 4 redo write broadcast ack time 2474064348 2474064.348 11.2.0.3.0 12004 1 redo write broadcast ack time 930969 930.969 11.2.0.3.0 12004 1 redo write broadcast ack time 930969 930.969 11.2.0.3.0 12004 1 redo write time 4343 43430.000 11.2.0.3.0 12004 1 redo write time 4343 43430.000 11.2.0.3.0 12004 1 redo write time 4343 43430.000 11.2.0.3.0 12004 1 redo write broadcast ack time 930969 930.969 11.2.0.3.0 12004 1 redo write broadcast ack count 8584 11.2.0.3.0 12004 1 redo write broadcast ack count 8584 11.2.0.3.0 12004 1 redo writes 16534 11.2.0.3.0 12004 1 redo writes 16534 11.2.0.3.0 12004 1 redo writes 16534 11.2.0.3.0 12004 1 redo write broadcast ack count 8584 11.2.0.3.0 12004 2 redo write broadcast lgwr post 10 11.2.0.3.0 12004 2 redo write broadcast lgwr post 10 11.2.0.3.0 12004 2 redo write time 307154 3071540.000 11.2.0.3.0 12004 2 redo write time 307154 3071540.000 11.2.0.3.0 12004 2 redo write time 307154 3071540.000 11.2.0.3.0 12004 2 redo write broadcast ack count 769353 11.2.0.3.0 12004 2 redo write broadcast ack count 769353 11.2.0.3.0 12004 2 redo write broadcast ack count 769353 11.2.0.3.0 12004 2 redo writes 1429909 11.2.0.3.0 12004 2 redo writes 1429909 11.2.0.3.0 12004 2 redo writes 1429909 11.2.0.3.0 12004 2 redo write broadcast ack time 717950177 717950.177 11.2.0.3.0 12004 2 redo write broadcast ack time 717950177 717950.177 11.2.0.3.0 12004 2 redo write broadcast ack time 717950177 717950.177 11.2.0.3.0 12004 2 redo write broadcast lgwr post 10 11.2.0.3.0 12004 3 redo write broadcast ack time 940558 940.558 11.2.0.3.0 12004 3 redo write broadcast ack time 940558 940.558 11.2.0.3.0 12004 3 redo write time 2210 22100.000 11.2.0.3.0 12004 3 redo write time 2210 22100.000 11.2.0.3.0 12004 3 redo write time 2210 22100.000 11.2.0.3.0 12004 3 redo write broadcast ack time 940558 940.558 11.2.0.3.0 12004 3 redo write broadcast ack count 9758 11.2.0.3.0 12004 3 redo write broadcast ack count 9758 11.2.0.3.0 12004 3 redo writes 15030 11.2.0.3.0 12004 3 redo writes 15030 11.2.0.3.0 12004 3 redo writes 15030 11.2.0.3.0 12004 3 redo write broadcast ack count 9758 11.2.0.3.0 12004 4 redo write broadcast lgwr post 91 11.2.0.3.0 12004 4 redo write broadcast lgwr post 91 11.2.0.3.0 12004 4 redo write time 1904066 19040660.000 11.2.0.3.0 12004 4 redo write time 1904066 19040660.000 11.2.0.3.0 12004 4 redo write time 1904066 19040660.000 11.2.0.3.0 12004 4 redo write broadcast ack count 4071478 11.2.0.3.0 12004 4 redo write broadcast ack count 4071478 11.2.0.3.0 12004 4 redo write broadcast ack count 4071478 11.2.0.3.0 12004 4 redo writes 6560726 11.2.0.3.0 12004 4 redo writes 6560726 11.2.0.3.0 12004 4 redo writes 6560726 11.2.0.3.0 12004 4 redo write broadcast ack time 2474150478 2474150.478 11.2.0.3.0 12004 4 redo write broadcast lgwr post 91 11.2.0.3.0 12004 4 redo write broadcast ack time 2474150478 2474150.478 11.2.0.3.0 12004 4 redo write broadcast ack time 2474150478 2474150.478 AWR LFS AND OTHER RELATED WAITS FOR WORST LFS AWRs: APPROACH: These are the AWR snaps where the average 'log file sync' times were the highest. Look at related waits at those times. SNAP_ID INST NAME TOTAL_WAITS TOTAL_WAIT_TIME AVG_TIME_WAITED ---------- ---- ---------------------------------------- ----------- ----------------- ----------------- 12002 1 LNS ASYNC end of log 8052 1087677.181 135.082 12002 3 LNS ASYNC end of log 7084 811066.039 114.493 12002 2 LNS ASYNC end of log 1404161 122629988.406 87.333 12002 4 LNS ASYNC end of log 5914933 444519559.591 75.152 12002 4 log file switch completion 311 22264.457 71.590 12002 4 wait for scn ack 264 18254.171 69.145 12002 1 log file sync 672 44087.518 65.606 12002 2 log file switch completion 17 1103.977 64.940 12002 1 LNS wait on ATTACH 1 56.814 56.814 12002 3 LNS wait on ATTACH 1 50.170 50.170 12002 2 LNS wait on ATTACH 2 98.335 49.168 12002 4 LNS wait on ATTACH 3 145.093 48.364 12002 2 wait for scn ack 60 747.105 12.452 12002 3 LGWR-LNS wait on channel 158 1725.250 10.919 12002 1 LGWR-LNS wait on channel 190 2073.134 10.911 12002 1 LNS wait on SENDREQ 7976 86820.383 10.885 12002 4 LGWR-LNS wait on channel 87 938.285 10.785 12002 3 LNS wait on SENDREQ 7086 54784.877 7.731 12002 2 gc cr grant 2-way 3794318 21304130.215 5.615 12002 1 log file parallel write 8785 30791.547 3.505 12002 4 log file sync 1448060 4747362.294 3.278 12002 4 log file parallel write 6554474 18152010.406 2.769 12002 3 log file sync 1349 3726.670 2.763 12002 4 LNS wait on SENDREQ 6461457 16776303.653 2.596 12002 4 gc cr grant 2-way 17568450 43997772.292 2.504 12002 2 gc current block 2-way 2874957 7059154.506 2.455 12002 2 log file sync 414752 988001.648 2.382 12002 2 log file parallel write 1415193 2854074.766 2.017 12002 3 log file parallel write 7704 12760.274 1.656 12002 4 gc current block 2-way 7512721 10245932.882 1.364 12002 4 LNS wait on DETACH 3 3.678 1.226 12002 2 LNS wait on SENDREQ 1428081 1714474.726 1.201 12002 1 gcs log flush sync 190 212.773 1.120 12002 2 LNS wait on DETACH 2 1.885 .943 12002 2 gcs log flush sync 236857 208983.145 .882 12002 3 gcs log flush sync 158 118.364 .749 12002 4 gcs log flush sync 1392997 1037398.423 .745 12002 1 gc cr grant 2-way 22893 8139.746 .356 12002 3 gc current block 2-way 39764 7058.443 .178 12002 1 gc current block 2-way 27091 4675.091 .173 12002 3 gc cr grant 2-way 127350 17523.942 .138 12002 4 LGWR wait for redo copy 571693 50818.656 .089 12002 2 LGWR wait for redo copy 132334 7691.191 .058 12002 1 LGWR wait for redo copy 783 26.090 .033 12002 4 LNS wait on LGWR 1 .015 .015 12002 3 LNS wait on LGWR 1 .014 .014 12002 1 LNS wait on LGWR 1 .013 .013 12002 2 LNS wait on LGWR 1 .013 .013 12002 3 LGWR wait for redo copy 162 1.793 .011 12002 1 LNS wait on DETACH 1 .005 .005 12002 3 LNS wait on DETACH 1 .004 .004 12003 1 LNS ASYNC end of log 12113 1987542.522 164.083 12003 3 LNS ASYNC end of log 11928 1710073.261 143.366 12003 2 LNS ASYNC end of log 1416150 123527403.685 87.228 12003 4 LNS ASYNC end of log 5918937 445419203.730 75.253 12003 4 log file switch completion 311 22264.457 71.590 12003 4 wait for scn ack 264 18254.171 69.145 12003 2 log file switch completion 17 1103.977 64.940 12003 1 log file sync 710 44140.364 62.170 12003 1 LNS wait on ATTACH 1 56.814 56.814 12003 3 LNS wait on ATTACH 1 50.170 50.170 12003 2 LNS wait on ATTACH 2 98.335 49.168 12003 4 LNS wait on ATTACH 3 145.093 48.364 12003 2 wait for scn ack 60 747.105 12.452 12003 3 LGWR-LNS wait on channel 158 1725.250 10.919 12003 1 LGWR-LNS wait on channel 190 2073.134 10.911 12003 4 LGWR-LNS wait on channel 87 938.285 10.785 12003 1 LNS wait on SENDREQ 11854 87706.540 7.399 12003 2 gc cr grant 2-way 3871517 21314592.498 5.505 12003 3 LNS wait on SENDREQ 11653 55784.586 4.787 12003 4 log file sync 1448304 4747647.013 3.278 12003 1 log file parallel write 12672 38686.767 3.053 12003 4 log file parallel write 6558259 18154573.258 2.768 12003 4 LNS wait on SENDREQ 6465237 16777052.742 2.595 12003 3 log file sync 1658 4200.097 2.533 12003 4 gc cr grant 2-way 17603838 44001885.424 2.500 12003 2 gc current block 2-way 2881801 7063031.202 2.451 12003 2 log file sync 414787 988806.288 2.384 12003 2 log file parallel write 1427011 2864826.891 2.008 12003 3 log file parallel write 12271 17973.657 1.465 12003 4 gc current block 2-way 7527706 10249713.511 1.362 12003 1 gcs log flush sync 458 591.778 1.292 12003 4 LNS wait on DETACH 3 3.678 1.226 12003 2 LNS wait on SENDREQ 1439871 1717180.742 1.193 12003 3 gcs log flush sync 195 190.911 .979 12003 2 LNS wait on DETACH 2 1.885 .943 12003 2 gcs log flush sync 237209 209952.810 .885 12003 4 gcs log flush sync 1393026 1037414.836 .745 12003 1 gc cr grant 2-way 64031 12945.670 .202 12003 3 gc current block 2-way 84763 14555.321 .172 12003 1 gc current block 2-way 120001 17299.261 .144 12003 3 gc cr grant 2-way 138946 19894.479 .143 12003 4 LGWR wait for redo copy 571763 50821.121 .089 12003 2 LGWR wait for redo copy 133330 7702.231 .058 12003 3 LGWR wait for redo copy 390 15.901 .041 12003 1 LGWR wait for redo copy 806 26.427 .033 12003 4 LNS wait on LGWR 1 .015 .015 SNAP_ID INST NAME TOTAL_WAITS TOTAL_WAIT_TIME AVG_TIME_WAITED ---------- ---- ---------------------------------------- ----------- ----------------- ----------------- 12003 3 LNS wait on LGWR 1 .014 .014 12003 2 LNS wait on LGWR 1 .013 .013 12003 1 LNS wait on LGWR 1 .013 .013 12003 1 LNS wait on DETACH 1 .005 .005 12003 3 LNS wait on DETACH 1 .004 .004 12004 1 LNS ASYNC end of log 16049 2876827.288 179.253 12004 3 LNS ASYNC end of log 15025 2609012.071 173.645 12004 2 LNS ASYNC end of log 1419244 124423700.285 87.669 12004 4 LNS ASYNC end of log 5921677 446312574.792 75.369 12004 4 log file switch completion 311 22264.457 71.590 12004 4 wait for scn ack 264 18254.171 69.145 12004 2 log file switch completion 17 1103.977 64.940 12004 1 log file sync 783 44490.880 56.821 12004 1 LNS wait on ATTACH 1 56.814 56.814 12004 3 LNS wait on ATTACH 1 50.170 50.170 12004 2 LNS wait on ATTACH 2 98.335 49.168 12004 4 LNS wait on ATTACH 3 145.093 48.364 12004 2 wait for scn ack 60 747.105 12.452 12004 3 LGWR-LNS wait on channel 158 1725.250 10.919 12004 1 LGWR-LNS wait on channel 190 2073.134 10.911 12004 4 LGWR-LNS wait on channel 87 938.285 10.785 12004 1 LNS wait on SENDREQ 15631 99536.654 6.368 12004 2 gc cr grant 2-way 3873770 21315221.724 5.502 12004 3 LNS wait on SENDREQ 14416 60761.893 4.215 12004 4 log file sync 1448434 4747733.174 3.278 12004 4 log file parallel write 6560725 18156093.330 2.767 12004 4 LNS wait on SENDREQ 6467682 16786499.560 2.595 12004 1 log file parallel write 16534 41465.755 2.508 12004 4 gc cr grant 2-way 17676451 44007331.019 2.490 12004 2 gc current block 2-way 2890442 7068740.285 2.446 12004 2 log file sync 414883 988883.165 2.384 12004 3 log file sync 2057 4724.043 2.297 12004 2 log file parallel write 1429908 2866967.440 2.005 12004 4 gc current block 2-way 7567603 10254174.048 1.355 12004 3 log file parallel write 15022 20120.020 1.339 12004 4 LNS wait on DETACH 3 3.678 1.226 12004 2 LNS wait on SENDREQ 1442779 1723546.747 1.195 12004 1 gcs log flush sync 530 620.993 1.172 12004 2 LNS wait on DETACH 2 1.885 .943 12004 2 gcs log flush sync 237388 210037.296 .885 12004 3 gcs log flush sync 290 255.184 .880 12004 4 gcs log flush sync 1393069 1037433.423 .745 12004 3 gc current block 2-way 96280 19081.871 .198 12004 1 gc current block 2-way 144862 21423.658 .148 12004 3 gc cr grant 2-way 211146 25785.465 .122 12004 1 gc cr grant 2-way 201622 23679.224 .117 12004 4 LGWR wait for redo copy 571861 50824.661 .089 12004 2 LGWR wait for redo copy 133458 7708.004 .058 12004 3 LGWR wait for redo copy 540 23.203 .043 12004 1 LGWR wait for redo copy 1445 49.567 .034 12004 4 LNS wait on LGWR 1 .015 .015 12004 3 LNS wait on LGWR 1 .014 .014 12004 2 LNS wait on LGWR 1 .013 .013 12004 1 LNS wait on LGWR 1 .013 .013 12004 1 LNS wait on DETACH 1 .005 .005 12004 3 LNS wait on DETACH 1 .004 .004 AWR HISTOGRAM DATA FOR LFS AND OTHER RELATED WAITS FOR WORST LFS AWRs: Note: This query won't work on 10.2 - ORA-942 APPROACH: Look at the wait distribution for log file sync waits by looking at "wait_time_milli". Look at the high wait times then see if you can correlate those with other related wait events. SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 2 wait for scn ack 1 15 12002 2 wait for scn ack 2 10 12002 2 wait for scn ack 4 10 12002 2 wait for scn ack 8 4 12002 2 wait for scn ack 16 5 12002 2 wait for scn ack 32 10 12002 2 wait for scn ack 64 4 12002 2 wait for scn ack 128 2 12002 4 wait for scn ack 1 8 12002 4 wait for scn ack 2 22 12002 4 wait for scn ack 4 107 12002 4 wait for scn ack 8 46 12002 4 wait for scn ack 16 9 12002 4 wait for scn ack 32 14 12002 4 wait for scn ack 64 37 12002 4 wait for scn ack 128 1 12002 4 wait for scn ack 256 4 12002 4 wait for scn ack 512 6 12002 4 wait for scn ack 1024 5 12002 4 wait for scn ack 2048 5 12002 1 log file sync 1 625 12002 1 log file sync 2 23 12002 1 log file sync 4 3 12002 1 log file sync 8 3 12002 1 log file sync 16 2 12002 1 log file sync 32 1 12002 1 log file sync 64 9 12002 1 log file sync 128 1 12002 1 log file sync 4096 1 12002 1 log file sync 8192 1 12002 1 log file sync 16384 3 12002 2 log file sync 1 356126 12002 2 log file sync 2 24492 12002 2 log file sync 4 13935 12002 2 log file sync 8 6279 12002 2 log file sync 16 4442 12002 2 log file sync 32 3768 12002 2 log file sync 64 3710 12002 2 log file sync 128 1146 12002 2 log file sync 256 397 12002 2 log file sync 512 341 12002 2 log file sync 1024 65 12002 2 log file sync 2048 20 12002 2 log file sync 4096 5 12002 2 log file sync 8192 3 12002 2 log file sync 16384 1 12002 3 log file sync 1 335 12002 3 log file sync 2 399 12002 3 log file sync 4 545 12002 3 log file sync 8 20 12002 3 log file sync 16 11 12002 3 log file sync 32 18 12002 3 log file sync 64 21 12002 4 log file sync 1 1170647 12002 4 log file sync 2 122295 12002 4 log file sync 4 60014 12002 4 log file sync 8 27500 12002 4 log file sync 16 20298 12002 4 log file sync 32 18526 12002 4 log file sync 64 17243 12002 4 log file sync 128 7034 12002 4 log file sync 256 2718 12002 4 log file sync 512 1000 12002 4 log file sync 1024 432 12002 4 log file sync 2048 154 12002 4 log file sync 4096 56 12002 4 log file sync 8192 8 12002 4 log file sync 32768 1 12002 2 log file switch completion 16 1 12002 2 log file switch completion 64 9 12002 2 log file switch completion 128 6 12002 2 log file switch completion 256 1 12002 4 log file switch completion 1 3 12002 4 log file switch completion 2 4 12002 4 log file switch completion 4 1 12002 4 log file switch completion 8 3 12002 4 log file switch completion 16 9 12002 4 log file switch completion 32 48 12002 4 log file switch completion 64 114 12002 4 log file switch completion 128 101 12002 4 log file switch completion 256 25 12002 4 log file switch completion 512 1 12002 4 log file switch completion 1024 1 12002 4 log file switch completion 2048 1 12002 1 log file parallel write 1 8334 12002 1 log file parallel write 2 213 12002 1 log file parallel write 4 104 12002 1 log file parallel write 8 37 12002 1 log file parallel write 16 41 12002 1 log file parallel write 32 58 12002 1 log file parallel write 64 42 12002 1 log file parallel write 128 13 12002 1 log file parallel write 256 5 12002 1 log file parallel write 512 2 12002 1 log file parallel write 1024 1 12002 1 log file parallel write 2048 1 12002 1 log file parallel write 8192 1 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 1 log file parallel write 16384 1 12002 2 log file parallel write 1 1261493 12002 2 log file parallel write 2 44862 12002 2 log file parallel write 4 49280 12002 2 log file parallel write 8 9533 12002 2 log file parallel write 16 11339 12002 2 log file parallel write 32 16788 12002 2 log file parallel write 64 16147 12002 2 log file parallel write 128 4886 12002 2 log file parallel write 256 1267 12002 2 log file parallel write 512 428 12002 2 log file parallel write 1024 111 12002 2 log file parallel write 2048 70 12002 2 log file parallel write 4096 9 12002 2 log file parallel write 8192 1 12002 2 log file parallel write 16384 1 12002 3 log file parallel write 1 6310 12002 3 log file parallel write 2 1078 12002 3 log file parallel write 4 137 12002 3 log file parallel write 8 25 12002 3 log file parallel write 16 52 12002 3 log file parallel write 32 75 12002 3 log file parallel write 64 60 12002 3 log file parallel write 128 11 12002 3 log file parallel write 256 8 12002 3 log file parallel write 512 1 12002 3 log file parallel write 1024 1 12002 4 log file parallel write 1 5308910 12002 4 log file parallel write 2 320657 12002 4 log file parallel write 4 545733 12002 4 log file parallel write 8 65481 12002 4 log file parallel write 16 64925 12002 4 log file parallel write 32 101034 12002 4 log file parallel write 64 103602 12002 4 log file parallel write 128 31966 12002 4 log file parallel write 256 8268 12002 4 log file parallel write 512 2633 12002 4 log file parallel write 1024 854 12002 4 log file parallel write 2048 355 12002 4 log file parallel write 4096 78 12002 4 log file parallel write 8192 2 12002 4 log file parallel write 16384 1 12002 1 gcs log flush sync 1 157 12002 1 gcs log flush sync 2 27 12002 1 gcs log flush sync 4 21 12002 1 gcs log flush sync 8 7 12002 1 gcs log flush sync 16 5 12002 2 gcs log flush sync 1 203847 12002 2 gcs log flush sync 2 11729 12002 2 gcs log flush sync 4 7086 12002 2 gcs log flush sync 8 5048 12002 2 gcs log flush sync 16 9133 12002 2 gcs log flush sync 32 37 12002 2 gcs log flush sync 64 21 12002 2 gcs log flush sync 128 2 12002 3 gcs log flush sync 1 154 12002 3 gcs log flush sync 2 6 12002 3 gcs log flush sync 4 3 12002 3 gcs log flush sync 8 5 12002 3 gcs log flush sync 16 3 12002 4 gcs log flush sync 1 1235793 12002 4 gcs log flush sync 2 56029 12002 4 gcs log flush sync 4 34429 12002 4 gcs log flush sync 8 24781 12002 4 gcs log flush sync 16 41969 12002 4 gcs log flush sync 32 1 12002 1 gc current block 2-way 1 26894 12002 1 gc current block 2-way 2 117 12002 1 gc current block 2-way 4 70 12002 1 gc current block 2-way 8 45 12002 1 gc current block 2-way 16 19 12002 1 gc current block 2-way 32 22 12002 1 gc current block 2-way 64 8 12002 1 gc current block 2-way 128 2 12002 2 gc current block 2-way 1 2824486 12002 2 gc current block 2-way 2 15295 12002 2 gc current block 2-way 4 13799 12002 2 gc current block 2-way 8 11406 12002 2 gc current block 2-way 16 5506 12002 2 gc current block 2-way 32 1999 12002 2 gc current block 2-way 64 1356 12002 2 gc current block 2-way 128 871 12002 2 gc current block 2-way 256 232 12002 2 gc current block 2-way 512 36 12002 2 gc current block 2-way 1024 21 12002 2 gc current block 2-way 2048 6 12002 2 gc current block 2-way 4096 4 12002 2 gc current block 2-way 8192 1 12002 2 gc current block 2-way 32768 3 12002 2 gc current block 2-way 65536 13 12002 2 gc current block 2-way 131072 26 12002 2 gc current block 2-way 262144 18 12002 3 gc current block 2-way 1 39556 12002 3 gc current block 2-way 2 115 12002 3 gc current block 2-way 4 70 12002 3 gc current block 2-way 8 45 12002 3 gc current block 2-way 16 60 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 3 gc current block 2-way 32 53 12002 3 gc current block 2-way 64 8 12002 4 gc current block 2-way 1 7449033 12002 4 gc current block 2-way 2 26745 12002 4 gc current block 2-way 4 12496 12002 4 gc current block 2-way 8 7529 12002 4 gc current block 2-way 16 5717 12002 4 gc current block 2-way 32 4144 12002 4 gc current block 2-way 64 3015 12002 4 gc current block 2-way 128 1737 12002 4 gc current block 2-way 256 646 12002 4 gc current block 2-way 512 211 12002 4 gc current block 2-way 1024 69 12002 4 gc current block 2-way 2048 20 12002 4 gc current block 2-way 4096 15 12002 4 gc current block 2-way 8192 8 12002 4 gc current block 2-way 16384 12 12002 4 gc current block 2-way 32768 13 12002 4 gc current block 2-way 65536 16 12002 4 gc current block 2-way 131072 33 12002 4 gc current block 2-way 262144 24 12002 1 gc cr grant 2-way 1 22134 12002 1 gc cr grant 2-way 2 247 12002 1 gc cr grant 2-way 4 174 12002 1 gc cr grant 2-way 8 129 12002 1 gc cr grant 2-way 16 102 12002 1 gc cr grant 2-way 32 75 12002 1 gc cr grant 2-way 64 23 12002 1 gc cr grant 2-way 128 8 12002 2 gc cr grant 2-way 1 3742006 12002 2 gc cr grant 2-way 2 21186 12002 2 gc cr grant 2-way 4 11313 12002 2 gc cr grant 2-way 8 7412 12002 2 gc cr grant 2-way 16 5835 12002 2 gc cr grant 2-way 32 3859 12002 2 gc cr grant 2-way 64 2888 12002 2 gc cr grant 2-way 128 1777 12002 2 gc cr grant 2-way 256 201 12002 2 gc cr grant 2-way 512 21 12002 2 gc cr grant 2-way 1024 4 12002 2 gc cr grant 2-way 2048 7 12002 2 gc cr grant 2-way 4096 6 12002 2 gc cr grant 2-way 8192 1 12002 2 gc cr grant 2-way 16384 9 12002 2 gc cr grant 2-way 32768 7 12002 2 gc cr grant 2-way 65536 29 12002 2 gc cr grant 2-way 131072 95 12002 2 gc cr grant 2-way 262144 52 12002 3 gc cr grant 2-way 1 126278 12002 3 gc cr grant 2-way 2 343 12002 3 gc cr grant 2-way 4 284 12002 3 gc cr grant 2-way 8 180 12002 3 gc cr grant 2-way 16 140 12002 3 gc cr grant 2-way 32 86 12002 3 gc cr grant 2-way 64 38 12002 3 gc cr grant 2-way 128 2 12002 4 gc cr grant 2-way 1 17336663 12002 4 gc cr grant 2-way 2 85427 12002 4 gc cr grant 2-way 4 46059 12002 4 gc cr grant 2-way 8 29375 12002 4 gc cr grant 2-way 16 24435 12002 4 gc cr grant 2-way 32 19692 12002 4 gc cr grant 2-way 64 15051 12002 4 gc cr grant 2-way 128 7406 12002 4 gc cr grant 2-way 256 1257 12002 4 gc cr grant 2-way 512 371 12002 4 gc cr grant 2-way 1024 95 12002 4 gc cr grant 2-way 2048 40 12002 4 gc cr grant 2-way 4096 11 12002 4 gc cr grant 2-way 8192 36 12002 4 gc cr grant 2-way 16384 53 12002 4 gc cr grant 2-way 32768 53 12002 4 gc cr grant 2-way 65536 76 12002 4 gc cr grant 2-way 131072 99 12002 4 gc cr grant 2-way 262144 111 12002 4 gc cr grant 2-way 524288 9 12002 1 LNS wait on SENDREQ 1 7390 12002 1 LNS wait on SENDREQ 2 104 12002 1 LNS wait on SENDREQ 4 218 12002 1 LNS wait on SENDREQ 8 186 12002 1 LNS wait on SENDREQ 16 130 12002 1 LNS wait on SENDREQ 32 7 12002 1 LNS wait on SENDREQ 2048 1 12002 1 LNS wait on SENDREQ 4096 2 12002 1 LNS wait on SENDREQ 8192 1 12002 1 LNS wait on SENDREQ 16384 4 12002 1 LNS wait on SENDREQ 32768 1 12002 2 LNS wait on SENDREQ 1 1296677 12002 2 LNS wait on SENDREQ 2 28009 12002 2 LNS wait on SENDREQ 4 14588 12002 2 LNS wait on SENDREQ 8 16679 12002 2 LNS wait on SENDREQ 16 41921 12002 2 LNS wait on SENDREQ 32 30267 12002 2 LNS wait on SENDREQ 64 813 12002 2 LNS wait on SENDREQ 128 42 12002 2 LNS wait on SENDREQ 256 52 12002 2 LNS wait on SENDREQ 512 27 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 2 LNS wait on SENDREQ 1024 8 12002 2 LNS wait on SENDREQ 2048 6 12002 2 LNS wait on SENDREQ 4096 3 12002 2 LNS wait on SENDREQ 8192 2 12002 2 LNS wait on SENDREQ 16384 5 12002 2 LNS wait on SENDREQ 32768 3 12002 3 LNS wait on SENDREQ 1 5688 12002 3 LNS wait on SENDREQ 2 117 12002 3 LNS wait on SENDREQ 4 109 12002 3 LNS wait on SENDREQ 8 131 12002 3 LNS wait on SENDREQ 16 1081 12002 3 LNS wait on SENDREQ 32 11 12002 3 LNS wait on SENDREQ 4096 1 12002 3 LNS wait on SENDREQ 16384 1 12002 3 LNS wait on SENDREQ 32768 1 12002 4 LNS wait on SENDREQ 1 5483491 12002 4 LNS wait on SENDREQ 2 106067 12002 4 LNS wait on SENDREQ 4 70403 12002 4 LNS wait on SENDREQ 8 73682 12002 4 LNS wait on SENDREQ 16 285893 12002 4 LNS wait on SENDREQ 32 416297 12002 4 LNS wait on SENDREQ 64 22790 12002 4 LNS wait on SENDREQ 128 397 12002 4 LNS wait on SENDREQ 256 1123 12002 4 LNS wait on SENDREQ 512 817 12002 4 LNS wait on SENDREQ 1024 219 12002 4 LNS wait on SENDREQ 2048 113 12002 4 LNS wait on SENDREQ 4096 67 12002 4 LNS wait on SENDREQ 8192 63 12002 4 LNS wait on SENDREQ 16384 35 12002 4 LNS wait on SENDREQ 32768 17 12002 4 LNS wait on SENDREQ 65536 8 12002 1 LNS wait on LGWR 1 1 12002 2 LNS wait on LGWR 1 1 12002 3 LNS wait on LGWR 1 1 12002 4 LNS wait on LGWR 1 1 12002 1 LNS wait on DETACH 1 1 12002 2 LNS wait on DETACH 1 1 12002 2 LNS wait on DETACH 2 1 12002 3 LNS wait on DETACH 1 1 12002 4 LNS wait on DETACH 1 1 12002 4 LNS wait on DETACH 2 2 12002 1 LNS wait on ATTACH 64 1 12002 2 LNS wait on ATTACH 64 2 12002 3 LNS wait on ATTACH 64 1 12002 4 LNS wait on ATTACH 64 3 12002 1 LNS ASYNC end of log 1 1735 12002 1 LNS ASYNC end of log 2 263 12002 1 LNS ASYNC end of log 4 362 12002 1 LNS ASYNC end of log 8 332 12002 1 LNS ASYNC end of log 16 283 12002 1 LNS ASYNC end of log 32 573 12002 1 LNS ASYNC end of log 64 464 12002 1 LNS ASYNC end of log 128 1612 12002 1 LNS ASYNC end of log 256 1411 12002 1 LNS ASYNC end of log 512 590 12002 1 LNS ASYNC end of log 1024 495 12002 2 LNS ASYNC end of log 1 203994 12002 2 LNS ASYNC end of log 2 66463 12002 2 LNS ASYNC end of log 4 138525 12002 2 LNS ASYNC end of log 8 116539 12002 2 LNS ASYNC end of log 16 73469 12002 2 LNS ASYNC end of log 32 191678 12002 2 LNS ASYNC end of log 64 117758 12002 2 LNS ASYNC end of log 128 276371 12002 2 LNS ASYNC end of log 256 109123 12002 2 LNS ASYNC end of log 512 62935 12002 2 LNS ASYNC end of log 1024 48327 12002 2 LNS ASYNC end of log 2048 1 12002 3 LNS ASYNC end of log 1 1196 12002 3 LNS ASYNC end of log 2 132 12002 3 LNS ASYNC end of log 4 237 12002 3 LNS ASYNC end of log 8 562 12002 3 LNS ASYNC end of log 16 199 12002 3 LNS ASYNC end of log 32 344 12002 3 LNS ASYNC end of log 64 649 12002 3 LNS ASYNC end of log 128 2070 12002 3 LNS ASYNC end of log 256 1022 12002 3 LNS ASYNC end of log 512 454 12002 3 LNS ASYNC end of log 1024 273 12002 4 LNS ASYNC end of log 1 891665 12002 4 LNS ASYNC end of log 2 640258 12002 4 LNS ASYNC end of log 4 487397 12002 4 LNS ASYNC end of log 8 487178 12002 4 LNS ASYNC end of log 16 353539 12002 4 LNS ASYNC end of log 32 661911 12002 4 LNS ASYNC end of log 64 521300 12002 4 LNS ASYNC end of log 128 1016317 12002 4 LNS ASYNC end of log 256 476596 12002 4 LNS ASYNC end of log 512 220230 12002 4 LNS ASYNC end of log 1024 158545 12002 4 LNS ASYNC end of log 2048 22 12002 1 LGWR-LNS wait on channel 1 1 12002 1 LGWR-LNS wait on channel 8 1 12002 1 LGWR-LNS wait on channel 16 188 12002 3 LGWR-LNS wait on channel 1 1 12002 3 LGWR-LNS wait on channel 8 1 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 3 LGWR-LNS wait on channel 16 156 12002 4 LGWR-LNS wait on channel 1 1 12002 4 LGWR-LNS wait on channel 4 1 12002 4 LGWR-LNS wait on channel 16 85 12002 1 LGWR wait for redo copy 1 784 12002 2 LGWR wait for redo copy 1 130659 12002 2 LGWR wait for redo copy 2 1342 12002 2 LGWR wait for redo copy 4 354 12002 2 LGWR wait for redo copy 8 27 12002 2 LGWR wait for redo copy 16 7 12002 2 LGWR wait for redo copy 32 8 12002 2 LGWR wait for redo copy 64 2 12002 2 LGWR wait for redo copy 128 1 12002 3 LGWR wait for redo copy 1 163 12002 4 LGWR wait for redo copy 1 567099 12002 4 LGWR wait for redo copy 2 2676 12002 4 LGWR wait for redo copy 4 825 12002 4 LGWR wait for redo copy 8 424 12002 4 LGWR wait for redo copy 16 283 12002 4 LGWR wait for redo copy 32 191 12002 4 LGWR wait for redo copy 64 129 12002 4 LGWR wait for redo copy 128 59 12002 4 LGWR wait for redo copy 256 7 12003 2 wait for scn ack 1 15 12003 2 wait for scn ack 2 10 12003 2 wait for scn ack 4 10 12003 2 wait for scn ack 8 4 12003 2 wait for scn ack 16 5 12003 2 wait for scn ack 32 10 12003 2 wait for scn ack 64 4 12003 2 wait for scn ack 128 2 12003 4 wait for scn ack 1 8 12003 4 wait for scn ack 2 22 12003 4 wait for scn ack 4 107 12003 4 wait for scn ack 8 46 12003 4 wait for scn ack 16 9 12003 4 wait for scn ack 32 14 12003 4 wait for scn ack 64 37 12003 4 wait for scn ack 128 1 12003 4 wait for scn ack 256 4 12003 4 wait for scn ack 512 6 12003 4 wait for scn ack 1024 5 12003 4 wait for scn ack 2048 5 12003 1 log file sync 1 657 12003 1 log file sync 2 27 12003 1 log file sync 4 3 12003 1 log file sync 8 5 12003 1 log file sync 16 2 12003 1 log file sync 32 2 12003 1 log file sync 64 9 12003 1 log file sync 128 1 12003 1 log file sync 4096 1 12003 1 log file sync 8192 1 12003 1 log file sync 16384 3 12003 2 log file sync 1 356156 12003 2 log file sync 2 24494 12003 2 log file sync 4 13935 12003 2 log file sync 8 6280 12003 2 log file sync 16 4442 12003 2 log file sync 32 3769 12003 2 log file sync 64 3710 12003 2 log file sync 128 1146 12003 2 log file sync 256 397 12003 2 log file sync 512 341 12003 2 log file sync 1024 66 12003 2 log file sync 2048 20 12003 2 log file sync 4096 5 12003 2 log file sync 8192 3 12003 2 log file sync 16384 1 12003 3 log file sync 1 626 12003 3 log file sync 2 406 12003 3 log file sync 4 547 12003 3 log file sync 8 21 12003 3 log file sync 16 13 12003 3 log file sync 32 23 12003 3 log file sync 64 21 12003 3 log file sync 256 1 12003 4 log file sync 1 1170870 12003 4 log file sync 2 122305 12003 4 log file sync 4 60019 12003 4 log file sync 8 27502 12003 4 log file sync 16 20299 12003 4 log file sync 32 18527 12003 4 log file sync 64 17245 12003 4 log file sync 128 7034 12003 4 log file sync 256 2718 12003 4 log file sync 512 1000 12003 4 log file sync 1024 432 12003 4 log file sync 2048 154 12003 4 log file sync 4096 56 12003 4 log file sync 8192 8 12003 4 log file sync 32768 1 12003 2 log file switch completion 16 1 12003 2 log file switch completion 64 9 12003 2 log file switch completion 128 6 12003 2 log file switch completion 256 1 12003 4 log file switch completion 1 3 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 4 log file switch completion 2 4 12003 4 log file switch completion 4 1 12003 4 log file switch completion 8 3 12003 4 log file switch completion 16 9 12003 4 log file switch completion 32 48 12003 4 log file switch completion 64 114 12003 4 log file switch completion 128 101 12003 4 log file switch completion 256 25 12003 4 log file switch completion 512 1 12003 4 log file switch completion 1024 1 12003 4 log file switch completion 2048 1 12003 1 log file parallel write 1 11937 12003 1 log file parallel write 2 305 12003 1 log file parallel write 4 146 12003 1 log file parallel write 8 56 12003 1 log file parallel write 16 63 12003 1 log file parallel write 32 82 12003 1 log file parallel write 64 55 12003 1 log file parallel write 128 23 12003 1 log file parallel write 256 8 12003 1 log file parallel write 512 4 12003 1 log file parallel write 1024 3 12003 1 log file parallel write 2048 2 12003 1 log file parallel write 8192 1 12003 1 log file parallel write 16384 1 12003 2 log file parallel write 1 1271644 12003 2 log file parallel write 2 45167 12003 2 log file parallel write 4 49485 12003 2 log file parallel write 8 9617 12003 2 log file parallel write 16 11380 12003 2 log file parallel write 32 16824 12003 2 log file parallel write 64 16183 12003 2 log file parallel write 128 4897 12003 2 log file parallel write 256 1270 12003 2 log file parallel write 512 430 12003 2 log file parallel write 1024 112 12003 2 log file parallel write 2048 70 12003 2 log file parallel write 4096 9 12003 2 log file parallel write 8192 1 12003 2 log file parallel write 16384 1 12003 3 log file parallel write 1 10619 12003 3 log file parallel write 2 1157 12003 3 log file parallel write 4 183 12003 3 log file parallel write 8 49 12003 3 log file parallel write 16 66 12003 3 log file parallel write 32 96 12003 3 log file parallel write 64 83 12003 3 log file parallel write 128 20 12003 3 log file parallel write 256 11 12003 3 log file parallel write 512 3 12003 3 log file parallel write 1024 1 12003 4 log file parallel write 1 5312453 12003 4 log file parallel write 2 320741 12003 4 log file parallel write 4 545806 12003 4 log file parallel write 8 65508 12003 4 log file parallel write 16 64941 12003 4 log file parallel write 32 101043 12003 4 log file parallel write 64 103614 12003 4 log file parallel write 128 31967 12003 4 log file parallel write 256 8269 12003 4 log file parallel write 512 2633 12003 4 log file parallel write 1024 854 12003 4 log file parallel write 2048 355 12003 4 log file parallel write 4096 78 12003 4 log file parallel write 8192 2 12003 4 log file parallel write 16384 1 12003 1 gcs log flush sync 1 354 12003 1 gcs log flush sync 2 38 12003 1 gcs log flush sync 4 29 12003 1 gcs log flush sync 8 20 12003 1 gcs log flush sync 16 23 12003 2 gcs log flush sync 1 204113 12003 2 gcs log flush sync 2 11738 12003 2 gcs log flush sync 4 7097 12003 2 gcs log flush sync 8 5066 12003 2 gcs log flush sync 16 9201 12003 2 gcs log flush sync 32 37 12003 2 gcs log flush sync 64 21 12003 2 gcs log flush sync 128 2 12003 3 gcs log flush sync 1 180 12003 3 gcs log flush sync 2 8 12003 3 gcs log flush sync 4 3 12003 3 gcs log flush sync 8 5 12003 3 gcs log flush sync 16 9 12003 4 gcs log flush sync 1 1235826 12003 4 gcs log flush sync 2 56029 12003 4 gcs log flush sync 4 34431 12003 4 gcs log flush sync 8 24781 12003 4 gcs log flush sync 16 41969 12003 4 gcs log flush sync 32 1 12003 1 gc current block 2-way 1 119619 12003 1 gc current block 2-way 2 135 12003 1 gc current block 2-way 4 106 12003 1 gc current block 2-way 8 74 12003 1 gc current block 2-way 16 44 12003 1 gc current block 2-way 32 38 12003 1 gc current block 2-way 64 21 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 1 gc current block 2-way 128 2 12003 1 gc current block 2-way 256 1 12003 2 gc current block 2-way 1 2830869 12003 2 gc current block 2-way 2 15364 12003 2 gc current block 2-way 4 13842 12003 2 gc current block 2-way 8 11447 12003 2 gc current block 2-way 16 5542 12003 2 gc current block 2-way 32 2026 12003 2 gc current block 2-way 64 1374 12003 2 gc current block 2-way 128 876 12003 2 gc current block 2-way 256 234 12003 2 gc current block 2-way 512 36 12003 2 gc current block 2-way 1024 21 12003 2 gc current block 2-way 2048 6 12003 2 gc current block 2-way 4096 4 12003 2 gc current block 2-way 8192 1 12003 2 gc current block 2-way 32768 3 12003 2 gc current block 2-way 65536 13 12003 2 gc current block 2-way 131072 26 12003 2 gc current block 2-way 262144 18 12003 3 gc current block 2-way 1 84245 12003 3 gc current block 2-way 2 169 12003 3 gc current block 2-way 4 114 12003 3 gc current block 2-way 8 79 12003 3 gc current block 2-way 16 92 12003 3 gc current block 2-way 32 77 12003 3 gc current block 2-way 64 16 12003 3 gc current block 2-way 128 5 12003 4 gc current block 2-way 1 7463763 12003 4 gc current block 2-way 2 26832 12003 4 gc current block 2-way 4 12560 12003 4 gc current block 2-way 8 7559 12003 4 gc current block 2-way 16 5743 12003 4 gc current block 2-way 32 4158 12003 4 gc current block 2-way 64 3027 12003 4 gc current block 2-way 128 1742 12003 4 gc current block 2-way 256 646 12003 4 gc current block 2-way 512 211 12003 4 gc current block 2-way 1024 69 12003 4 gc current block 2-way 2048 20 12003 4 gc current block 2-way 4096 15 12003 4 gc current block 2-way 8192 8 12003 4 gc current block 2-way 16384 12 12003 4 gc current block 2-way 32768 13 12003 4 gc current block 2-way 65536 16 12003 4 gc current block 2-way 131072 33 12003 4 gc current block 2-way 262144 24 12003 1 gc cr grant 2-way 1 63124 12003 1 gc cr grant 2-way 2 302 12003 1 gc cr grant 2-way 4 204 12003 1 gc cr grant 2-way 8 151 12003 1 gc cr grant 2-way 16 119 12003 1 gc cr grant 2-way 32 92 12003 1 gc cr grant 2-way 64 29 12003 1 gc cr grant 2-way 128 12 12003 1 gc cr grant 2-way 256 1 12003 2 gc cr grant 2-way 1 3815007 12003 2 gc cr grant 2-way 2 21351 12003 2 gc cr grant 2-way 4 11424 12003 2 gc cr grant 2-way 8 7501 12003 2 gc cr grant 2-way 16 5884 12003 2 gc cr grant 2-way 32 3907 12003 2 gc cr grant 2-way 64 2911 12003 2 gc cr grant 2-way 128 1784 12003 2 gc cr grant 2-way 256 202 12003 2 gc cr grant 2-way 512 21 12003 2 gc cr grant 2-way 1024 4 12003 2 gc cr grant 2-way 2048 7 12003 2 gc cr grant 2-way 4096 6 12003 2 gc cr grant 2-way 8192 1 12003 2 gc cr grant 2-way 16384 9 12003 2 gc cr grant 2-way 32768 7 12003 2 gc cr grant 2-way 65536 29 12003 2 gc cr grant 2-way 131072 95 12003 2 gc cr grant 2-way 262144 52 12003 3 gc cr grant 2-way 1 137695 12003 3 gc cr grant 2-way 2 401 12003 3 gc cr grant 2-way 4 331 12003 3 gc cr grant 2-way 8 205 12003 3 gc cr grant 2-way 16 165 12003 3 gc cr grant 2-way 32 103 12003 3 gc cr grant 2-way 64 43 12003 3 gc cr grant 2-way 128 4 12003 4 gc cr grant 2-way 1 17371923 12003 4 gc cr grant 2-way 2 85470 12003 4 gc cr grant 2-way 4 46090 12003 4 gc cr grant 2-way 8 29394 12003 4 gc cr grant 2-way 16 24447 12003 4 gc cr grant 2-way 32 19702 12003 4 gc cr grant 2-way 64 15064 12003 4 gc cr grant 2-way 128 7409 12003 4 gc cr grant 2-way 256 1257 12003 4 gc cr grant 2-way 512 371 12003 4 gc cr grant 2-way 1024 95 12003 4 gc cr grant 2-way 2048 40 12003 4 gc cr grant 2-way 4096 11 12003 4 gc cr grant 2-way 8192 36 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 4 gc cr grant 2-way 16384 53 12003 4 gc cr grant 2-way 32768 53 12003 4 gc cr grant 2-way 65536 76 12003 4 gc cr grant 2-way 131072 99 12003 4 gc cr grant 2-way 262144 111 12003 4 gc cr grant 2-way 524288 9 12003 1 LNS wait on SENDREQ 1 11127 12003 1 LNS wait on SENDREQ 2 128 12003 1 LNS wait on SENDREQ 4 242 12003 1 LNS wait on SENDREQ 8 208 12003 1 LNS wait on SENDREQ 16 147 12003 1 LNS wait on SENDREQ 32 7 12003 1 LNS wait on SENDREQ 2048 1 12003 1 LNS wait on SENDREQ 4096 2 12003 1 LNS wait on SENDREQ 8192 1 12003 1 LNS wait on SENDREQ 16384 4 12003 1 LNS wait on SENDREQ 32768 1 12003 2 LNS wait on SENDREQ 1 1307328 12003 2 LNS wait on SENDREQ 2 28068 12003 2 LNS wait on SENDREQ 4 14644 12003 2 LNS wait on SENDREQ 8 16700 12003 2 LNS wait on SENDREQ 16 41945 12003 2 LNS wait on SENDREQ 32 30301 12003 2 LNS wait on SENDREQ 64 813 12003 2 LNS wait on SENDREQ 128 42 12003 2 LNS wait on SENDREQ 256 52 12003 2 LNS wait on SENDREQ 512 27 12003 2 LNS wait on SENDREQ 1024 8 12003 2 LNS wait on SENDREQ 2048 6 12003 2 LNS wait on SENDREQ 4096 3 12003 2 LNS wait on SENDREQ 8192 2 12003 2 LNS wait on SENDREQ 16384 5 12003 2 LNS wait on SENDREQ 32768 3 12003 3 LNS wait on SENDREQ 1 10119 12003 3 LNS wait on SENDREQ 2 157 12003 3 LNS wait on SENDREQ 4 127 12003 3 LNS wait on SENDREQ 8 151 12003 3 LNS wait on SENDREQ 16 1100 12003 3 LNS wait on SENDREQ 32 13 12003 3 LNS wait on SENDREQ 4096 1 12003 3 LNS wait on SENDREQ 16384 1 12003 3 LNS wait on SENDREQ 32768 1 12003 4 LNS wait on SENDREQ 1 5487196 12003 4 LNS wait on SENDREQ 2 106085 12003 4 LNS wait on SENDREQ 4 70410 12003 4 LNS wait on SENDREQ 8 73695 12003 4 LNS wait on SENDREQ 16 285910 12003 4 LNS wait on SENDREQ 32 416297 12003 4 LNS wait on SENDREQ 64 22790 12003 4 LNS wait on SENDREQ 128 397 12003 4 LNS wait on SENDREQ 256 1123 12003 4 LNS wait on SENDREQ 512 817 12003 4 LNS wait on SENDREQ 1024 219 12003 4 LNS wait on SENDREQ 2048 113 12003 4 LNS wait on SENDREQ 4096 67 12003 4 LNS wait on SENDREQ 8192 63 12003 4 LNS wait on SENDREQ 16384 35 12003 4 LNS wait on SENDREQ 32768 17 12003 4 LNS wait on SENDREQ 65536 8 12003 1 LNS wait on LGWR 1 1 12003 2 LNS wait on LGWR 1 1 12003 3 LNS wait on LGWR 1 1 12003 4 LNS wait on LGWR 1 1 12003 1 LNS wait on DETACH 1 1 12003 2 LNS wait on DETACH 1 1 12003 2 LNS wait on DETACH 2 1 12003 3 LNS wait on DETACH 1 1 12003 4 LNS wait on DETACH 1 1 12003 4 LNS wait on DETACH 2 2 12003 1 LNS wait on ATTACH 64 1 12003 2 LNS wait on ATTACH 64 2 12003 3 LNS wait on ATTACH 64 1 12003 4 LNS wait on ATTACH 64 3 12003 1 LNS ASYNC end of log 1 2116 12003 1 LNS ASYNC end of log 2 370 12003 1 LNS ASYNC end of log 4 532 12003 1 LNS ASYNC end of log 8 542 12003 1 LNS ASYNC end of log 16 466 12003 1 LNS ASYNC end of log 32 851 12003 1 LNS ASYNC end of log 64 744 12003 1 LNS ASYNC end of log 128 2507 12003 1 LNS ASYNC end of log 256 1896 12003 1 LNS ASYNC end of log 512 929 12003 1 LNS ASYNC end of log 1024 1174 12003 2 LNS ASYNC end of log 1 205354 12003 2 LNS ASYNC end of log 2 66865 12003 2 LNS ASYNC end of log 4 140123 12003 2 LNS ASYNC end of log 8 120264 12003 2 LNS ASYNC end of log 16 73985 12003 2 LNS ASYNC end of log 32 192953 12003 2 LNS ASYNC end of log 64 118049 12003 2 LNS ASYNC end of log 128 276842 12003 2 LNS ASYNC end of log 256 109549 12003 2 LNS ASYNC end of log 512 63237 12003 2 LNS ASYNC end of log 1024 49004 12003 2 LNS ASYNC end of log 2048 1 12003 3 LNS ASYNC end of log 1 2659 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 3 LNS ASYNC end of log 2 240 12003 3 LNS ASYNC end of log 4 356 12003 3 LNS ASYNC end of log 8 745 12003 3 LNS ASYNC end of log 16 333 12003 3 LNS ASYNC end of log 32 607 12003 3 LNS ASYNC end of log 64 897 12003 3 LNS ASYNC end of log 128 2885 12003 3 LNS ASYNC end of log 256 1532 12003 3 LNS ASYNC end of log 512 741 12003 3 LNS ASYNC end of log 1024 950 12003 4 LNS ASYNC end of log 1 892381 12003 4 LNS ASYNC end of log 2 640332 12003 4 LNS ASYNC end of log 4 487476 12003 4 LNS ASYNC end of log 8 487328 12003 4 LNS ASYNC end of log 16 353660 12003 4 LNS ASYNC end of log 32 662123 12003 4 LNS ASYNC end of log 64 521549 12003 4 LNS ASYNC end of log 128 1017134 12003 4 LNS ASYNC end of log 256 477194 12003 4 LNS ASYNC end of log 512 220530 12003 4 LNS ASYNC end of log 1024 159213 12003 4 LNS ASYNC end of log 2048 22 12003 1 LGWR-LNS wait on channel 1 1 12003 1 LGWR-LNS wait on channel 8 1 12003 1 LGWR-LNS wait on channel 16 188 12003 3 LGWR-LNS wait on channel 1 1 12003 3 LGWR-LNS wait on channel 8 1 12003 3 LGWR-LNS wait on channel 16 156 12003 4 LGWR-LNS wait on channel 1 1 12003 4 LGWR-LNS wait on channel 4 1 12003 4 LGWR-LNS wait on channel 16 85 12003 1 LGWR wait for redo copy 1 806 12003 2 LGWR wait for redo copy 1 131588 12003 2 LGWR wait for redo copy 2 1343 12003 2 LGWR wait for redo copy 4 354 12003 2 LGWR wait for redo copy 8 27 12003 2 LGWR wait for redo copy 16 7 12003 2 LGWR wait for redo copy 32 8 12003 2 LGWR wait for redo copy 64 2 12003 2 LGWR wait for redo copy 128 1 12003 3 LGWR wait for redo copy 1 390 12003 4 LGWR wait for redo copy 1 567169 12003 4 LGWR wait for redo copy 2 2676 12003 4 LGWR wait for redo copy 4 825 12003 4 LGWR wait for redo copy 8 424 12003 4 LGWR wait for redo copy 16 283 12003 4 LGWR wait for redo copy 32 191 12003 4 LGWR wait for redo copy 64 129 12003 4 LGWR wait for redo copy 128 59 12003 4 LGWR wait for redo copy 256 7 12004 2 wait for scn ack 1 15 12004 2 wait for scn ack 2 10 12004 2 wait for scn ack 4 10 12004 2 wait for scn ack 8 4 12004 2 wait for scn ack 16 5 12004 2 wait for scn ack 32 10 12004 2 wait for scn ack 64 4 12004 2 wait for scn ack 128 2 12004 4 wait for scn ack 1 8 12004 4 wait for scn ack 2 22 12004 4 wait for scn ack 4 107 12004 4 wait for scn ack 8 46 12004 4 wait for scn ack 16 9 12004 4 wait for scn ack 32 14 12004 4 wait for scn ack 64 37 12004 4 wait for scn ack 128 1 12004 4 wait for scn ack 256 4 12004 4 wait for scn ack 512 6 12004 4 wait for scn ack 1024 5 12004 4 wait for scn ack 2048 5 12004 1 log file sync 1 711 12004 1 log file sync 2 36 12004 1 log file sync 4 6 12004 1 log file sync 8 6 12004 1 log file sync 16 3 12004 1 log file sync 32 2 12004 1 log file sync 64 12 12004 1 log file sync 128 3 12004 1 log file sync 4096 1 12004 1 log file sync 8192 1 12004 1 log file sync 16384 3 12004 2 log file sync 1 356242 12004 2 log file sync 2 24501 12004 2 log file sync 4 13936 12004 2 log file sync 8 6280 12004 2 log file sync 16 4444 12004 2 log file sync 32 3769 12004 2 log file sync 64 3710 12004 2 log file sync 128 1146 12004 2 log file sync 256 397 12004 2 log file sync 512 341 12004 2 log file sync 1024 66 12004 2 log file sync 2048 20 12004 2 log file sync 4096 5 12004 2 log file sync 8192 3 12004 2 log file sync 16384 1 12004 3 log file sync 1 995 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 3 log file sync 2 417 12004 3 log file sync 4 548 12004 3 log file sync 8 26 12004 3 log file sync 16 17 12004 3 log file sync 32 29 12004 3 log file sync 64 24 12004 3 log file sync 256 1 12004 4 log file sync 1 1170995 12004 4 log file sync 2 122308 12004 4 log file sync 4 60019 12004 4 log file sync 8 27503 12004 4 log file sync 16 20299 12004 4 log file sync 32 18528 12004 4 log file sync 64 17245 12004 4 log file sync 128 7034 12004 4 log file sync 256 2718 12004 4 log file sync 512 1000 12004 4 log file sync 1024 432 12004 4 log file sync 2048 154 12004 4 log file sync 4096 56 12004 4 log file sync 8192 8 12004 4 log file sync 32768 1 12004 2 log file switch completion 16 1 12004 2 log file switch completion 64 9 12004 2 log file switch completion 128 6 12004 2 log file switch completion 256 1 12004 4 log file switch completion 1 3 12004 4 log file switch completion 2 4 12004 4 log file switch completion 4 1 12004 4 log file switch completion 8 3 12004 4 log file switch completion 16 9 12004 4 log file switch completion 32 48 12004 4 log file switch completion 64 114 12004 4 log file switch completion 128 101 12004 4 log file switch completion 256 25 12004 4 log file switch completion 512 1 12004 4 log file switch completion 1024 1 12004 4 log file switch completion 2048 1 12004 1 log file parallel write 1 15558 12004 1 log file parallel write 2 386 12004 1 log file parallel write 4 240 12004 1 log file parallel write 8 68 12004 1 log file parallel write 16 77 12004 1 log file parallel write 32 98 12004 1 log file parallel write 64 69 12004 1 log file parallel write 128 28 12004 1 log file parallel write 256 8 12004 1 log file parallel write 512 4 12004 1 log file parallel write 1024 3 12004 1 log file parallel write 2048 2 12004 1 log file parallel write 8192 1 12004 1 log file parallel write 16384 1 12004 2 log file parallel write 1 1274395 12004 2 log file parallel write 2 45206 12004 2 log file parallel write 4 49517 12004 2 log file parallel write 8 9626 12004 2 log file parallel write 16 11388 12004 2 log file parallel write 32 16846 12004 2 log file parallel write 64 16196 12004 2 log file parallel write 128 4898 12004 2 log file parallel write 256 1270 12004 2 log file parallel write 512 430 12004 2 log file parallel write 1024 112 12004 2 log file parallel write 2048 70 12004 2 log file parallel write 4096 9 12004 2 log file parallel write 8192 1 12004 2 log file parallel write 16384 1 12004 3 log file parallel write 1 13257 12004 3 log file parallel write 2 1182 12004 3 log file parallel write 4 208 12004 3 log file parallel write 8 62 12004 3 log file parallel write 16 76 12004 3 log file parallel write 32 117 12004 3 log file parallel write 64 96 12004 3 log file parallel write 128 22 12004 3 log file parallel write 256 11 12004 3 log file parallel write 512 3 12004 3 log file parallel write 1024 1 12004 4 log file parallel write 1 5314865 12004 4 log file parallel write 2 320760 12004 4 log file parallel write 4 545815 12004 4 log file parallel write 8 65515 12004 4 log file parallel write 16 64947 12004 4 log file parallel write 32 101055 12004 4 log file parallel write 64 103624 12004 4 log file parallel write 128 31968 12004 4 log file parallel write 256 8269 12004 4 log file parallel write 512 2633 12004 4 log file parallel write 1024 854 12004 4 log file parallel write 2048 355 12004 4 log file parallel write 4096 78 12004 4 log file parallel write 8192 2 12004 4 log file parallel write 16384 1 12004 1 gcs log flush sync 1 416 12004 1 gcs log flush sync 2 44 12004 1 gcs log flush sync 4 30 12004 1 gcs log flush sync 8 20 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 1 gcs log flush sync 16 23 12004 2 gcs log flush sync 1 204255 12004 2 gcs log flush sync 2 11741 12004 2 gcs log flush sync 4 7097 12004 2 gcs log flush sync 8 5068 12004 2 gcs log flush sync 16 9204 12004 2 gcs log flush sync 32 37 12004 2 gcs log flush sync 64 21 12004 2 gcs log flush sync 128 2 12004 3 gcs log flush sync 1 261 12004 3 gcs log flush sync 2 12 12004 3 gcs log flush sync 4 4 12004 3 gcs log flush sync 8 6 12004 3 gcs log flush sync 16 14 12004 4 gcs log flush sync 1 1235869 12004 4 gcs log flush sync 2 56033 12004 4 gcs log flush sync 4 34431 12004 4 gcs log flush sync 8 24781 12004 4 gcs log flush sync 16 41969 12004 4 gcs log flush sync 32 1 12004 1 gc current block 2-way 1 144362 12004 1 gc current block 2-way 2 167 12004 1 gc current block 2-way 4 136 12004 1 gc current block 2-way 8 94 12004 1 gc current block 2-way 16 65 12004 1 gc current block 2-way 32 58 12004 1 gc current block 2-way 64 26 12004 1 gc current block 2-way 128 3 12004 1 gc current block 2-way 256 1 12004 2 gc current block 2-way 1 2838978 12004 2 gc current block 2-way 2 15521 12004 2 gc current block 2-way 4 13969 12004 2 gc current block 2-way 8 11526 12004 2 gc current block 2-way 16 5618 12004 2 gc current block 2-way 32 2071 12004 2 gc current block 2-way 64 1394 12004 2 gc current block 2-way 128 883 12004 2 gc current block 2-way 256 234 12004 2 gc current block 2-way 512 36 12004 2 gc current block 2-way 1024 21 12004 2 gc current block 2-way 2048 6 12004 2 gc current block 2-way 4096 4 12004 2 gc current block 2-way 8192 1 12004 2 gc current block 2-way 32768 3 12004 2 gc current block 2-way 65536 13 12004 2 gc current block 2-way 131072 26 12004 2 gc current block 2-way 262144 18 12004 3 gc current block 2-way 1 95380 12004 3 gc current block 2-way 2 271 12004 3 gc current block 2-way 4 227 12004 3 gc current block 2-way 8 149 12004 3 gc current block 2-way 16 147 12004 3 gc current block 2-way 32 111 12004 3 gc current block 2-way 64 31 12004 3 gc current block 2-way 128 7 12004 4 gc current block 2-way 1 7503633 12004 4 gc current block 2-way 2 26838 12004 4 gc current block 2-way 4 12575 12004 4 gc current block 2-way 8 7559 12004 4 gc current block 2-way 16 5749 12004 4 gc current block 2-way 32 4158 12004 4 gc current block 2-way 64 3027 12004 4 gc current block 2-way 128 1743 12004 4 gc current block 2-way 256 646 12004 4 gc current block 2-way 512 211 12004 4 gc current block 2-way 1024 69 12004 4 gc current block 2-way 2048 20 12004 4 gc current block 2-way 4096 15 12004 4 gc current block 2-way 8192 8 12004 4 gc current block 2-way 16384 12 12004 4 gc current block 2-way 32768 13 12004 4 gc current block 2-way 65536 16 12004 4 gc current block 2-way 131072 33 12004 4 gc current block 2-way 262144 24 12004 1 gc cr grant 2-way 1 200669 12004 1 gc cr grant 2-way 2 328 12004 1 gc cr grant 2-way 4 217 12004 1 gc cr grant 2-way 8 163 12004 1 gc cr grant 2-way 16 126 12004 1 gc cr grant 2-way 32 99 12004 1 gc cr grant 2-way 64 39 12004 1 gc cr grant 2-way 128 15 12004 1 gc cr grant 2-way 256 1 12004 2 gc cr grant 2-way 1 3817195 12004 2 gc cr grant 2-way 2 21366 12004 2 gc cr grant 2-way 4 11441 12004 2 gc cr grant 2-way 8 7517 12004 2 gc cr grant 2-way 16 5889 12004 2 gc cr grant 2-way 32 3911 12004 2 gc cr grant 2-way 64 2914 12004 2 gc cr grant 2-way 128 1784 12004 2 gc cr grant 2-way 256 202 12004 2 gc cr grant 2-way 512 21 12004 2 gc cr grant 2-way 1024 4 12004 2 gc cr grant 2-way 2048 7 12004 2 gc cr grant 2-way 4096 6 12004 2 gc cr grant 2-way 8192 1 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 2 gc cr grant 2-way 16384 9 12004 2 gc cr grant 2-way 32768 7 12004 2 gc cr grant 2-way 65536 29 12004 2 gc cr grant 2-way 131072 95 12004 2 gc cr grant 2-way 262144 52 12004 3 gc cr grant 2-way 1 209814 12004 3 gc cr grant 2-way 2 425 12004 3 gc cr grant 2-way 4 352 12004 3 gc cr grant 2-way 8 221 12004 3 gc cr grant 2-way 16 176 12004 3 gc cr grant 2-way 32 109 12004 3 gc cr grant 2-way 64 45 12004 3 gc cr grant 2-way 128 4 12004 4 gc cr grant 2-way 1 17444480 12004 4 gc cr grant 2-way 2 85488 12004 4 gc cr grant 2-way 4 46107 12004 4 gc cr grant 2-way 8 29403 12004 4 gc cr grant 2-way 16 24454 12004 4 gc cr grant 2-way 32 19702 12004 4 gc cr grant 2-way 64 15064 12004 4 gc cr grant 2-way 128 7409 12004 4 gc cr grant 2-way 256 1257 12004 4 gc cr grant 2-way 512 371 12004 4 gc cr grant 2-way 1024 95 12004 4 gc cr grant 2-way 2048 40 12004 4 gc cr grant 2-way 4096 11 12004 4 gc cr grant 2-way 8192 36 12004 4 gc cr grant 2-way 16384 53 12004 4 gc cr grant 2-way 32768 53 12004 4 gc cr grant 2-way 65536 76 12004 4 gc cr grant 2-way 131072 99 12004 4 gc cr grant 2-way 262144 111 12004 4 gc cr grant 2-way 524288 9 12004 1 LNS wait on SENDREQ 1 14573 12004 1 LNS wait on SENDREQ 2 211 12004 1 LNS wait on SENDREQ 4 278 12004 1 LNS wait on SENDREQ 8 243 12004 1 LNS wait on SENDREQ 16 301 12004 1 LNS wait on SENDREQ 32 22 12004 1 LNS wait on SENDREQ 2048 2 12004 1 LNS wait on SENDREQ 4096 3 12004 1 LNS wait on SENDREQ 8192 2 12004 1 LNS wait on SENDREQ 16384 4 12004 1 LNS wait on SENDREQ 32768 1 12004 2 LNS wait on SENDREQ 1 1310095 12004 2 LNS wait on SENDREQ 2 28088 12004 2 LNS wait on SENDREQ 4 14662 12004 2 LNS wait on SENDREQ 8 16723 12004 2 LNS wait on SENDREQ 16 41987 12004 2 LNS wait on SENDREQ 32 30317 12004 2 LNS wait on SENDREQ 64 813 12004 2 LNS wait on SENDREQ 128 42 12004 2 LNS wait on SENDREQ 256 52 12004 2 LNS wait on SENDREQ 512 27 12004 2 LNS wait on SENDREQ 1024 8 12004 2 LNS wait on SENDREQ 2048 8 12004 2 LNS wait on SENDREQ 4096 4 12004 2 LNS wait on SENDREQ 8192 2 12004 2 LNS wait on SENDREQ 16384 5 12004 2 LNS wait on SENDREQ 32768 3 12004 3 LNS wait on SENDREQ 1 12773 12004 3 LNS wait on SENDREQ 2 181 12004 3 LNS wait on SENDREQ 4 148 12004 3 LNS wait on SENDREQ 8 159 12004 3 LNS wait on SENDREQ 16 1137 12004 3 LNS wait on SENDREQ 32 25 12004 3 LNS wait on SENDREQ 512 1 12004 3 LNS wait on SENDREQ 1024 1 12004 3 LNS wait on SENDREQ 4096 2 12004 3 LNS wait on SENDREQ 16384 1 12004 3 LNS wait on SENDREQ 32768 1 12004 4 LNS wait on SENDREQ 1 5489586 12004 4 LNS wait on SENDREQ 2 106112 12004 4 LNS wait on SENDREQ 4 70427 12004 4 LNS wait on SENDREQ 8 73704 12004 4 LNS wait on SENDREQ 16 285918 12004 4 LNS wait on SENDREQ 32 416298 12004 4 LNS wait on SENDREQ 64 22790 12004 4 LNS wait on SENDREQ 128 397 12004 4 LNS wait on SENDREQ 256 1123 12004 4 LNS wait on SENDREQ 512 817 12004 4 LNS wait on SENDREQ 1024 219 12004 4 LNS wait on SENDREQ 2048 113 12004 4 LNS wait on SENDREQ 4096 70 12004 4 LNS wait on SENDREQ 8192 63 12004 4 LNS wait on SENDREQ 16384 35 12004 4 LNS wait on SENDREQ 32768 17 12004 4 LNS wait on SENDREQ 65536 8 12004 1 LNS wait on LGWR 1 1 12004 2 LNS wait on LGWR 1 1 12004 3 LNS wait on LGWR 1 1 12004 4 LNS wait on LGWR 1 1 12004 1 LNS wait on DETACH 1 1 12004 2 LNS wait on DETACH 1 1 12004 2 LNS wait on DETACH 2 1 12004 3 LNS wait on DETACH 1 1 12004 4 LNS wait on DETACH 1 1 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 4 LNS wait on DETACH 2 2 12004 1 LNS wait on ATTACH 64 1 12004 2 LNS wait on ATTACH 64 2 12004 3 LNS wait on ATTACH 64 1 12004 4 LNS wait on ATTACH 64 3 12004 1 LNS ASYNC end of log 1 3197 12004 1 LNS ASYNC end of log 2 519 12004 1 LNS ASYNC end of log 4 739 12004 1 LNS ASYNC end of log 8 709 12004 1 LNS ASYNC end of log 16 536 12004 1 LNS ASYNC end of log 32 1241 12004 1 LNS ASYNC end of log 64 896 12004 1 LNS ASYNC end of log 128 2748 12004 1 LNS ASYNC end of log 256 2252 12004 1 LNS ASYNC end of log 512 1304 12004 1 LNS ASYNC end of log 1024 1917 12004 2 LNS ASYNC end of log 1 205999 12004 2 LNS ASYNC end of log 2 66959 12004 2 LNS ASYNC end of log 4 140190 12004 2 LNS ASYNC end of log 8 120314 12004 2 LNS ASYNC end of log 16 74045 12004 2 LNS ASYNC end of log 32 193069 12004 2 LNS ASYNC end of log 64 118207 12004 2 LNS ASYNC end of log 128 277227 12004 2 LNS ASYNC end of log 256 109933 12004 2 LNS ASYNC end of log 512 63610 12004 2 LNS ASYNC end of log 1024 49747 12004 2 LNS ASYNC end of log 2048 1 12004 3 LNS ASYNC end of log 1 3523 12004 3 LNS ASYNC end of log 2 305 12004 3 LNS ASYNC end of log 4 416 12004 3 LNS ASYNC end of log 8 798 12004 3 LNS ASYNC end of log 16 386 12004 3 LNS ASYNC end of log 32 722 12004 3 LNS ASYNC end of log 64 1046 12004 3 LNS ASYNC end of log 128 3208 12004 3 LNS ASYNC end of log 256 1837 12004 3 LNS ASYNC end of log 512 1095 12004 3 LNS ASYNC end of log 1024 1702 12004 4 LNS ASYNC end of log 1 892902 12004 4 LNS ASYNC end of log 2 640377 12004 4 LNS ASYNC end of log 4 487506 12004 4 LNS ASYNC end of log 8 487362 12004 4 LNS ASYNC end of log 16 353699 12004 4 LNS ASYNC end of log 32 662210 12004 4 LNS ASYNC end of log 64 521689 12004 4 LNS ASYNC end of log 128 1017477 12004 4 LNS ASYNC end of log 256 477549 12004 4 LNS ASYNC end of log 512 220973 12004 4 LNS ASYNC end of log 1024 159927 12004 4 LNS ASYNC end of log 2048 22 12004 1 LGWR-LNS wait on channel 1 1 12004 1 LGWR-LNS wait on channel 8 1 12004 1 LGWR-LNS wait on channel 16 188 12004 3 LGWR-LNS wait on channel 1 1 12004 3 LGWR-LNS wait on channel 8 1 12004 3 LGWR-LNS wait on channel 16 156 12004 4 LGWR-LNS wait on channel 1 1 12004 4 LGWR-LNS wait on channel 4 1 12004 4 LGWR-LNS wait on channel 16 85 12004 1 LGWR wait for redo copy 1 1445 12004 2 LGWR wait for redo copy 1 131716 12004 2 LGWR wait for redo copy 2 1343 12004 2 LGWR wait for redo copy 4 354 12004 2 LGWR wait for redo copy 8 27 12004 2 LGWR wait for redo copy 16 7 12004 2 LGWR wait for redo copy 32 8 12004 2 LGWR wait for redo copy 64 2 12004 2 LGWR wait for redo copy 128 1 12004 3 LGWR wait for redo copy 1 540 12004 4 LGWR wait for redo copy 1 567267 12004 4 LGWR wait for redo copy 2 2676 12004 4 LGWR wait for redo copy 4 825 12004 4 LGWR wait for redo copy 8 424 12004 4 LGWR wait for redo copy 16 283 12004 4 LGWR wait for redo copy 32 191 12004 4 LGWR wait for redo copy 64 129 12004 4 LGWR wait for redo copy 128 59 12004 4 LGWR wait for redo copy 256 7 ORDERED BY WAIT_TIME_MILLI Note: This query won't work on 10.2 - ORA-942 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 1 log file sync 1 625 12002 1 log file parallel write 1 8334 12002 1 gcs log flush sync 1 157 12002 1 gc current block 2-way 1 26894 12002 1 gc cr grant 2-way 1 22134 12002 1 LNS wait on SENDREQ 1 7390 12002 1 LNS wait on LGWR 1 1 12002 1 LNS wait on DETACH 1 1 12002 1 LNS ASYNC end of log 1 1735 12002 1 LGWR-LNS wait on channel 1 1 12002 1 LGWR wait for redo copy 1 784 12002 2 wait for scn ack 1 15 12002 2 log file sync 1 356126 12002 2 log file parallel write 1 1261493 12002 2 gcs log flush sync 1 203847 12002 2 gc current block 2-way 1 2824486 12002 2 gc cr grant 2-way 1 3742006 12002 2 LNS wait on SENDREQ 1 1296677 12002 2 LNS wait on LGWR 1 1 12002 2 LNS wait on DETACH 1 1 12002 2 LNS ASYNC end of log 1 203994 12002 2 LGWR wait for redo copy 1 130659 12002 3 log file sync 1 335 12002 3 log file parallel write 1 6310 12002 3 gcs log flush sync 1 154 12002 3 gc current block 2-way 1 39556 12002 3 gc cr grant 2-way 1 126278 12002 3 LNS wait on SENDREQ 1 5688 12002 3 LNS wait on LGWR 1 1 12002 3 LNS wait on DETACH 1 1 12002 3 LNS ASYNC end of log 1 1196 12002 3 LGWR-LNS wait on channel 1 1 12002 3 LGWR wait for redo copy 1 163 12002 4 wait for scn ack 1 8 12002 4 log file sync 1 1170647 12002 4 log file switch completion 1 3 12002 4 log file parallel write 1 5308910 12002 4 gcs log flush sync 1 1235793 12002 4 gc current block 2-way 1 7449033 12002 4 gc cr grant 2-way 1 17336663 12002 4 LNS wait on SENDREQ 1 5483491 12002 4 LNS wait on LGWR 1 1 12002 4 LNS wait on DETACH 1 1 12002 4 LNS ASYNC end of log 1 891665 12002 4 LGWR-LNS wait on channel 1 1 12002 4 LGWR wait for redo copy 1 567099 12002 1 log file sync 2 23 12002 1 log file parallel write 2 213 12002 1 gcs log flush sync 2 27 12002 1 gc current block 2-way 2 117 12002 1 gc cr grant 2-way 2 247 12002 1 LNS wait on SENDREQ 2 104 12002 1 LNS ASYNC end of log 2 263 12002 2 wait for scn ack 2 10 12002 2 log file sync 2 24492 12002 2 log file parallel write 2 44862 12002 2 gcs log flush sync 2 11729 12002 2 gc current block 2-way 2 15295 12002 2 gc cr grant 2-way 2 21186 12002 2 LNS wait on SENDREQ 2 28009 12002 2 LNS wait on DETACH 2 1 12002 2 LNS ASYNC end of log 2 66463 12002 2 LGWR wait for redo copy 2 1342 12002 3 log file sync 2 399 12002 3 log file parallel write 2 1078 12002 3 gcs log flush sync 2 6 12002 3 gc current block 2-way 2 115 12002 3 gc cr grant 2-way 2 343 12002 3 LNS wait on SENDREQ 2 117 12002 3 LNS ASYNC end of log 2 132 12002 4 wait for scn ack 2 22 12002 4 log file sync 2 122295 12002 4 log file switch completion 2 4 12002 4 log file parallel write 2 320657 12002 4 gcs log flush sync 2 56029 12002 4 gc current block 2-way 2 26745 12002 4 gc cr grant 2-way 2 85427 12002 4 LNS wait on SENDREQ 2 106067 12002 4 LNS wait on DETACH 2 2 12002 4 LNS ASYNC end of log 2 640258 12002 4 LGWR wait for redo copy 2 2676 12002 1 log file sync 4 3 12002 1 log file parallel write 4 104 12002 1 gcs log flush sync 4 21 12002 1 gc current block 2-way 4 70 12002 1 gc cr grant 2-way 4 174 12002 1 LNS wait on SENDREQ 4 218 12002 1 LNS ASYNC end of log 4 362 12002 2 wait for scn ack 4 10 12002 2 log file sync 4 13935 12002 2 log file parallel write 4 49280 12002 2 gcs log flush sync 4 7086 12002 2 gc current block 2-way 4 13799 12002 2 gc cr grant 2-way 4 11313 12002 2 LNS wait on SENDREQ 4 14588 12002 2 LNS ASYNC end of log 4 138525 12002 2 LGWR wait for redo copy 4 354 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 3 log file sync 4 545 12002 3 log file parallel write 4 137 12002 3 gcs log flush sync 4 3 12002 3 gc current block 2-way 4 70 12002 3 gc cr grant 2-way 4 284 12002 3 LNS wait on SENDREQ 4 109 12002 3 LNS ASYNC end of log 4 237 12002 4 wait for scn ack 4 107 12002 4 log file sync 4 60014 12002 4 log file switch completion 4 1 12002 4 log file parallel write 4 545733 12002 4 gcs log flush sync 4 34429 12002 4 gc current block 2-way 4 12496 12002 4 gc cr grant 2-way 4 46059 12002 4 LNS wait on SENDREQ 4 70403 12002 4 LNS ASYNC end of log 4 487397 12002 4 LGWR-LNS wait on channel 4 1 12002 4 LGWR wait for redo copy 4 825 12002 1 log file sync 8 3 12002 1 log file parallel write 8 37 12002 1 gcs log flush sync 8 7 12002 1 gc current block 2-way 8 45 12002 1 gc cr grant 2-way 8 129 12002 1 LNS wait on SENDREQ 8 186 12002 1 LNS ASYNC end of log 8 332 12002 1 LGWR-LNS wait on channel 8 1 12002 2 wait for scn ack 8 4 12002 2 log file sync 8 6279 12002 2 log file parallel write 8 9533 12002 2 gcs log flush sync 8 5048 12002 2 gc current block 2-way 8 11406 12002 2 gc cr grant 2-way 8 7412 12002 2 LNS wait on SENDREQ 8 16679 12002 2 LNS ASYNC end of log 8 116539 12002 2 LGWR wait for redo copy 8 27 12002 3 log file sync 8 20 12002 3 log file parallel write 8 25 12002 3 gcs log flush sync 8 5 12002 3 gc current block 2-way 8 45 12002 3 gc cr grant 2-way 8 180 12002 3 LNS wait on SENDREQ 8 131 12002 3 LNS ASYNC end of log 8 562 12002 3 LGWR-LNS wait on channel 8 1 12002 4 wait for scn ack 8 46 12002 4 log file sync 8 27500 12002 4 log file switch completion 8 3 12002 4 log file parallel write 8 65481 12002 4 gcs log flush sync 8 24781 12002 4 gc current block 2-way 8 7529 12002 4 gc cr grant 2-way 8 29375 12002 4 LNS wait on SENDREQ 8 73682 12002 4 LNS ASYNC end of log 8 487178 12002 4 LGWR wait for redo copy 8 424 12002 1 log file sync 16 2 12002 1 log file parallel write 16 41 12002 1 gcs log flush sync 16 5 12002 1 gc current block 2-way 16 19 12002 1 gc cr grant 2-way 16 102 12002 1 LNS wait on SENDREQ 16 130 12002 1 LNS ASYNC end of log 16 283 12002 1 LGWR-LNS wait on channel 16 188 12002 2 wait for scn ack 16 5 12002 2 log file sync 16 4442 12002 2 log file switch completion 16 1 12002 2 log file parallel write 16 11339 12002 2 gcs log flush sync 16 9133 12002 2 gc current block 2-way 16 5506 12002 2 gc cr grant 2-way 16 5835 12002 2 LNS wait on SENDREQ 16 41921 12002 2 LNS ASYNC end of log 16 73469 12002 2 LGWR wait for redo copy 16 7 12002 3 log file sync 16 11 12002 3 log file parallel write 16 52 12002 3 gcs log flush sync 16 3 12002 3 gc current block 2-way 16 60 12002 3 gc cr grant 2-way 16 140 12002 3 LNS wait on SENDREQ 16 1081 12002 3 LNS ASYNC end of log 16 199 12002 3 LGWR-LNS wait on channel 16 156 12002 4 wait for scn ack 16 9 12002 4 log file sync 16 20298 12002 4 log file switch completion 16 9 12002 4 log file parallel write 16 64925 12002 4 gcs log flush sync 16 41969 12002 4 gc current block 2-way 16 5717 12002 4 gc cr grant 2-way 16 24435 12002 4 LNS wait on SENDREQ 16 285893 12002 4 LNS ASYNC end of log 16 353539 12002 4 LGWR-LNS wait on channel 16 85 12002 4 LGWR wait for redo copy 16 283 12002 1 log file sync 32 1 12002 1 log file parallel write 32 58 12002 1 gc current block 2-way 32 22 12002 1 gc cr grant 2-way 32 75 12002 1 LNS wait on SENDREQ 32 7 12002 1 LNS ASYNC end of log 32 573 12002 2 wait for scn ack 32 10 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 2 log file sync 32 3768 12002 2 log file parallel write 32 16788 12002 2 gcs log flush sync 32 37 12002 2 gc current block 2-way 32 1999 12002 2 gc cr grant 2-way 32 3859 12002 2 LNS wait on SENDREQ 32 30267 12002 2 LNS ASYNC end of log 32 191678 12002 2 LGWR wait for redo copy 32 8 12002 3 log file sync 32 18 12002 3 log file parallel write 32 75 12002 3 gc current block 2-way 32 53 12002 3 gc cr grant 2-way 32 86 12002 3 LNS wait on SENDREQ 32 11 12002 3 LNS ASYNC end of log 32 344 12002 4 wait for scn ack 32 14 12002 4 log file sync 32 18526 12002 4 log file switch completion 32 48 12002 4 log file parallel write 32 101034 12002 4 gcs log flush sync 32 1 12002 4 gc current block 2-way 32 4144 12002 4 gc cr grant 2-way 32 19692 12002 4 LNS wait on SENDREQ 32 416297 12002 4 LNS ASYNC end of log 32 661911 12002 4 LGWR wait for redo copy 32 191 12002 1 log file sync 64 9 12002 1 log file parallel write 64 42 12002 1 gc current block 2-way 64 8 12002 1 gc cr grant 2-way 64 23 12002 1 LNS wait on ATTACH 64 1 12002 1 LNS ASYNC end of log 64 464 12002 2 wait for scn ack 64 4 12002 2 log file sync 64 3710 12002 2 log file switch completion 64 9 12002 2 log file parallel write 64 16147 12002 2 gcs log flush sync 64 21 12002 2 gc current block 2-way 64 1356 12002 2 gc cr grant 2-way 64 2888 12002 2 LNS wait on SENDREQ 64 813 12002 2 LNS wait on ATTACH 64 2 12002 2 LNS ASYNC end of log 64 117758 12002 2 LGWR wait for redo copy 64 2 12002 3 log file sync 64 21 12002 3 log file parallel write 64 60 12002 3 gc current block 2-way 64 8 12002 3 gc cr grant 2-way 64 38 12002 3 LNS wait on ATTACH 64 1 12002 3 LNS ASYNC end of log 64 649 12002 4 wait for scn ack 64 37 12002 4 log file sync 64 17243 12002 4 log file switch completion 64 114 12002 4 log file parallel write 64 103602 12002 4 gc current block 2-way 64 3015 12002 4 gc cr grant 2-way 64 15051 12002 4 LNS wait on SENDREQ 64 22790 12002 4 LNS wait on ATTACH 64 3 12002 4 LNS ASYNC end of log 64 521300 12002 4 LGWR wait for redo copy 64 129 12002 1 log file sync 128 1 12002 1 log file parallel write 128 13 12002 1 gc current block 2-way 128 2 12002 1 gc cr grant 2-way 128 8 12002 1 LNS ASYNC end of log 128 1612 12002 2 wait for scn ack 128 2 12002 2 log file sync 128 1146 12002 2 log file switch completion 128 6 12002 2 log file parallel write 128 4886 12002 2 gcs log flush sync 128 2 12002 2 gc current block 2-way 128 871 12002 2 gc cr grant 2-way 128 1777 12002 2 LNS wait on SENDREQ 128 42 12002 2 LNS ASYNC end of log 128 276371 12002 2 LGWR wait for redo copy 128 1 12002 3 log file parallel write 128 11 12002 3 gc cr grant 2-way 128 2 12002 3 LNS ASYNC end of log 128 2070 12002 4 wait for scn ack 128 1 12002 4 log file sync 128 7034 12002 4 log file switch completion 128 101 12002 4 log file parallel write 128 31966 12002 4 gc current block 2-way 128 1737 12002 4 gc cr grant 2-way 128 7406 12002 4 LNS wait on SENDREQ 128 397 12002 4 LNS ASYNC end of log 128 1016317 12002 4 LGWR wait for redo copy 128 59 12002 1 log file parallel write 256 5 12002 1 LNS ASYNC end of log 256 1411 12002 2 log file sync 256 397 12002 2 log file switch completion 256 1 12002 2 log file parallel write 256 1267 12002 2 gc current block 2-way 256 232 12002 2 gc cr grant 2-way 256 201 12002 2 LNS wait on SENDREQ 256 52 12002 2 LNS ASYNC end of log 256 109123 12002 3 log file parallel write 256 8 12002 3 LNS ASYNC end of log 256 1022 12002 4 wait for scn ack 256 4 12002 4 log file sync 256 2718 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 4 log file switch completion 256 25 12002 4 log file parallel write 256 8268 12002 4 gc current block 2-way 256 646 12002 4 gc cr grant 2-way 256 1257 12002 4 LNS wait on SENDREQ 256 1123 12002 4 LNS ASYNC end of log 256 476596 12002 4 LGWR wait for redo copy 256 7 12002 1 log file parallel write 512 2 12002 1 LNS ASYNC end of log 512 590 12002 2 log file sync 512 341 12002 2 log file parallel write 512 428 12002 2 gc current block 2-way 512 36 12002 2 gc cr grant 2-way 512 21 12002 2 LNS wait on SENDREQ 512 27 12002 2 LNS ASYNC end of log 512 62935 12002 3 log file parallel write 512 1 12002 3 LNS ASYNC end of log 512 454 12002 4 wait for scn ack 512 6 12002 4 log file sync 512 1000 12002 4 log file switch completion 512 1 12002 4 log file parallel write 512 2633 12002 4 gc current block 2-way 512 211 12002 4 gc cr grant 2-way 512 371 12002 4 LNS wait on SENDREQ 512 817 12002 4 LNS ASYNC end of log 512 220230 12002 1 log file parallel write 1024 1 12002 1 LNS ASYNC end of log 1024 495 12002 2 log file sync 1024 65 12002 2 log file parallel write 1024 111 12002 2 gc current block 2-way 1024 21 12002 2 gc cr grant 2-way 1024 4 12002 2 LNS wait on SENDREQ 1024 8 12002 2 LNS ASYNC end of log 1024 48327 12002 3 log file parallel write 1024 1 12002 3 LNS ASYNC end of log 1024 273 12002 4 wait for scn ack 1024 5 12002 4 log file sync 1024 432 12002 4 log file switch completion 1024 1 12002 4 log file parallel write 1024 854 12002 4 gc current block 2-way 1024 69 12002 4 gc cr grant 2-way 1024 95 12002 4 LNS wait on SENDREQ 1024 219 12002 4 LNS ASYNC end of log 1024 158545 12002 1 log file parallel write 2048 1 12002 1 LNS wait on SENDREQ 2048 1 12002 2 log file sync 2048 20 12002 2 log file parallel write 2048 70 12002 2 gc current block 2-way 2048 6 12002 2 gc cr grant 2-way 2048 7 12002 2 LNS wait on SENDREQ 2048 6 12002 2 LNS ASYNC end of log 2048 1 12002 4 wait for scn ack 2048 5 12002 4 log file sync 2048 154 12002 4 log file switch completion 2048 1 12002 4 log file parallel write 2048 355 12002 4 gc current block 2-way 2048 20 12002 4 gc cr grant 2-way 2048 40 12002 4 LNS wait on SENDREQ 2048 113 12002 4 LNS ASYNC end of log 2048 22 12002 1 log file sync 4096 1 12002 1 LNS wait on SENDREQ 4096 2 12002 2 log file sync 4096 5 12002 2 log file parallel write 4096 9 12002 2 gc current block 2-way 4096 4 12002 2 gc cr grant 2-way 4096 6 12002 2 LNS wait on SENDREQ 4096 3 12002 3 LNS wait on SENDREQ 4096 1 12002 4 log file sync 4096 56 12002 4 log file parallel write 4096 78 12002 4 gc current block 2-way 4096 15 12002 4 gc cr grant 2-way 4096 11 12002 4 LNS wait on SENDREQ 4096 67 12002 1 log file sync 8192 1 12002 1 log file parallel write 8192 1 12002 1 LNS wait on SENDREQ 8192 1 12002 2 log file sync 8192 3 12002 2 log file parallel write 8192 1 12002 2 gc current block 2-way 8192 1 12002 2 gc cr grant 2-way 8192 1 12002 2 LNS wait on SENDREQ 8192 2 12002 4 log file sync 8192 8 12002 4 log file parallel write 8192 2 12002 4 gc current block 2-way 8192 8 12002 4 gc cr grant 2-way 8192 36 12002 4 LNS wait on SENDREQ 8192 63 12002 1 log file sync 16384 3 12002 1 log file parallel write 16384 1 12002 1 LNS wait on SENDREQ 16384 4 12002 2 log file sync 16384 1 12002 2 log file parallel write 16384 1 12002 2 gc cr grant 2-way 16384 9 12002 2 LNS wait on SENDREQ 16384 5 12002 3 LNS wait on SENDREQ 16384 1 12002 4 log file parallel write 16384 1 12002 4 gc current block 2-way 16384 12 12002 4 gc cr grant 2-way 16384 53 12002 4 LNS wait on SENDREQ 16384 35 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12002 1 LNS wait on SENDREQ 32768 1 12002 2 gc current block 2-way 32768 3 12002 2 gc cr grant 2-way 32768 7 12002 2 LNS wait on SENDREQ 32768 3 12002 3 LNS wait on SENDREQ 32768 1 12002 4 log file sync 32768 1 12002 4 gc current block 2-way 32768 13 12002 4 gc cr grant 2-way 32768 53 12002 4 LNS wait on SENDREQ 32768 17 12002 2 gc current block 2-way 65536 13 12002 2 gc cr grant 2-way 65536 29 12002 4 gc current block 2-way 65536 16 12002 4 gc cr grant 2-way 65536 76 12002 4 LNS wait on SENDREQ 65536 8 12002 2 gc current block 2-way 131072 26 12002 2 gc cr grant 2-way 131072 95 12002 4 gc current block 2-way 131072 33 12002 4 gc cr grant 2-way 131072 99 12002 2 gc current block 2-way 262144 18 12002 2 gc cr grant 2-way 262144 52 12002 4 gc current block 2-way 262144 24 12002 4 gc cr grant 2-way 262144 111 12002 4 gc cr grant 2-way 524288 9 12003 1 log file sync 1 657 12003 1 log file parallel write 1 11937 12003 1 gcs log flush sync 1 354 12003 1 gc current block 2-way 1 119619 12003 1 gc cr grant 2-way 1 63124 12003 1 LNS wait on SENDREQ 1 11127 12003 1 LNS wait on LGWR 1 1 12003 1 LNS wait on DETACH 1 1 12003 1 LNS ASYNC end of log 1 2116 12003 1 LGWR-LNS wait on channel 1 1 12003 1 LGWR wait for redo copy 1 806 12003 2 wait for scn ack 1 15 12003 2 log file sync 1 356156 12003 2 log file parallel write 1 1271644 12003 2 gcs log flush sync 1 204113 12003 2 gc current block 2-way 1 2830869 12003 2 gc cr grant 2-way 1 3815007 12003 2 LNS wait on SENDREQ 1 1307328 12003 2 LNS wait on LGWR 1 1 12003 2 LNS wait on DETACH 1 1 12003 2 LNS ASYNC end of log 1 205354 12003 2 LGWR wait for redo copy 1 131588 12003 3 log file sync 1 626 12003 3 log file parallel write 1 10619 12003 3 gcs log flush sync 1 180 12003 3 gc current block 2-way 1 84245 12003 3 gc cr grant 2-way 1 137695 12003 3 LNS wait on SENDREQ 1 10119 12003 3 LNS wait on LGWR 1 1 12003 3 LNS wait on DETACH 1 1 12003 3 LNS ASYNC end of log 1 2659 12003 3 LGWR-LNS wait on channel 1 1 12003 3 LGWR wait for redo copy 1 390 12003 4 wait for scn ack 1 8 12003 4 log file sync 1 1170870 12003 4 log file switch completion 1 3 12003 4 log file parallel write 1 5312453 12003 4 gcs log flush sync 1 1235826 12003 4 gc current block 2-way 1 7463763 12003 4 gc cr grant 2-way 1 17371923 12003 4 LNS wait on SENDREQ 1 5487196 12003 4 LNS wait on LGWR 1 1 12003 4 LNS wait on DETACH 1 1 12003 4 LNS ASYNC end of log 1 892381 12003 4 LGWR-LNS wait on channel 1 1 12003 4 LGWR wait for redo copy 1 567169 12003 1 log file sync 2 27 12003 1 log file parallel write 2 305 12003 1 gcs log flush sync 2 38 12003 1 gc current block 2-way 2 135 12003 1 gc cr grant 2-way 2 302 12003 1 LNS wait on SENDREQ 2 128 12003 1 LNS ASYNC end of log 2 370 12003 2 wait for scn ack 2 10 12003 2 log file sync 2 24494 12003 2 log file parallel write 2 45167 12003 2 gcs log flush sync 2 11738 12003 2 gc current block 2-way 2 15364 12003 2 gc cr grant 2-way 2 21351 12003 2 LNS wait on SENDREQ 2 28068 12003 2 LNS wait on DETACH 2 1 12003 2 LNS ASYNC end of log 2 66865 12003 2 LGWR wait for redo copy 2 1343 12003 3 log file sync 2 406 12003 3 log file parallel write 2 1157 12003 3 gcs log flush sync 2 8 12003 3 gc current block 2-way 2 169 12003 3 gc cr grant 2-way 2 401 12003 3 LNS wait on SENDREQ 2 157 12003 3 LNS ASYNC end of log 2 240 12003 4 wait for scn ack 2 22 12003 4 log file sync 2 122305 12003 4 log file switch completion 2 4 12003 4 log file parallel write 2 320741 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 4 gcs log flush sync 2 56029 12003 4 gc current block 2-way 2 26832 12003 4 gc cr grant 2-way 2 85470 12003 4 LNS wait on SENDREQ 2 106085 12003 4 LNS wait on DETACH 2 2 12003 4 LNS ASYNC end of log 2 640332 12003 4 LGWR wait for redo copy 2 2676 12003 1 log file sync 4 3 12003 1 log file parallel write 4 146 12003 1 gcs log flush sync 4 29 12003 1 gc current block 2-way 4 106 12003 1 gc cr grant 2-way 4 204 12003 1 LNS wait on SENDREQ 4 242 12003 1 LNS ASYNC end of log 4 532 12003 2 wait for scn ack 4 10 12003 2 log file sync 4 13935 12003 2 log file parallel write 4 49485 12003 2 gcs log flush sync 4 7097 12003 2 gc current block 2-way 4 13842 12003 2 gc cr grant 2-way 4 11424 12003 2 LNS wait on SENDREQ 4 14644 12003 2 LNS ASYNC end of log 4 140123 12003 2 LGWR wait for redo copy 4 354 12003 3 log file sync 4 547 12003 3 log file parallel write 4 183 12003 3 gcs log flush sync 4 3 12003 3 gc current block 2-way 4 114 12003 3 gc cr grant 2-way 4 331 12003 3 LNS wait on SENDREQ 4 127 12003 3 LNS ASYNC end of log 4 356 12003 4 wait for scn ack 4 107 12003 4 log file sync 4 60019 12003 4 log file switch completion 4 1 12003 4 log file parallel write 4 545806 12003 4 gcs log flush sync 4 34431 12003 4 gc current block 2-way 4 12560 12003 4 gc cr grant 2-way 4 46090 12003 4 LNS wait on SENDREQ 4 70410 12003 4 LNS ASYNC end of log 4 487476 12003 4 LGWR-LNS wait on channel 4 1 12003 4 LGWR wait for redo copy 4 825 12003 1 log file sync 8 5 12003 1 log file parallel write 8 56 12003 1 gcs log flush sync 8 20 12003 1 gc current block 2-way 8 74 12003 1 gc cr grant 2-way 8 151 12003 1 LNS wait on SENDREQ 8 208 12003 1 LNS ASYNC end of log 8 542 12003 1 LGWR-LNS wait on channel 8 1 12003 2 wait for scn ack 8 4 12003 2 log file sync 8 6280 12003 2 log file parallel write 8 9617 12003 2 gcs log flush sync 8 5066 12003 2 gc current block 2-way 8 11447 12003 2 gc cr grant 2-way 8 7501 12003 2 LNS wait on SENDREQ 8 16700 12003 2 LNS ASYNC end of log 8 120264 12003 2 LGWR wait for redo copy 8 27 12003 3 log file sync 8 21 12003 3 log file parallel write 8 49 12003 3 gcs log flush sync 8 5 12003 3 gc current block 2-way 8 79 12003 3 gc cr grant 2-way 8 205 12003 3 LNS wait on SENDREQ 8 151 12003 3 LNS ASYNC end of log 8 745 12003 3 LGWR-LNS wait on channel 8 1 12003 4 wait for scn ack 8 46 12003 4 log file sync 8 27502 12003 4 log file switch completion 8 3 12003 4 log file parallel write 8 65508 12003 4 gcs log flush sync 8 24781 12003 4 gc current block 2-way 8 7559 12003 4 gc cr grant 2-way 8 29394 12003 4 LNS wait on SENDREQ 8 73695 12003 4 LNS ASYNC end of log 8 487328 12003 4 LGWR wait for redo copy 8 424 12003 1 log file sync 16 2 12003 1 log file parallel write 16 63 12003 1 gcs log flush sync 16 23 12003 1 gc current block 2-way 16 44 12003 1 gc cr grant 2-way 16 119 12003 1 LNS wait on SENDREQ 16 147 12003 1 LNS ASYNC end of log 16 466 12003 1 LGWR-LNS wait on channel 16 188 12003 2 wait for scn ack 16 5 12003 2 log file sync 16 4442 12003 2 log file switch completion 16 1 12003 2 log file parallel write 16 11380 12003 2 gcs log flush sync 16 9201 12003 2 gc current block 2-way 16 5542 12003 2 gc cr grant 2-way 16 5884 12003 2 LNS wait on SENDREQ 16 41945 12003 2 LNS ASYNC end of log 16 73985 12003 2 LGWR wait for redo copy 16 7 12003 3 log file sync 16 13 12003 3 log file parallel write 16 66 12003 3 gcs log flush sync 16 9 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 3 gc current block 2-way 16 92 12003 3 gc cr grant 2-way 16 165 12003 3 LNS wait on SENDREQ 16 1100 12003 3 LNS ASYNC end of log 16 333 12003 3 LGWR-LNS wait on channel 16 156 12003 4 wait for scn ack 16 9 12003 4 log file sync 16 20299 12003 4 log file switch completion 16 9 12003 4 log file parallel write 16 64941 12003 4 gcs log flush sync 16 41969 12003 4 gc current block 2-way 16 5743 12003 4 gc cr grant 2-way 16 24447 12003 4 LNS wait on SENDREQ 16 285910 12003 4 LNS ASYNC end of log 16 353660 12003 4 LGWR-LNS wait on channel 16 85 12003 4 LGWR wait for redo copy 16 283 12003 1 log file sync 32 2 12003 1 log file parallel write 32 82 12003 1 gc current block 2-way 32 38 12003 1 gc cr grant 2-way 32 92 12003 1 LNS wait on SENDREQ 32 7 12003 1 LNS ASYNC end of log 32 851 12003 2 wait for scn ack 32 10 12003 2 log file sync 32 3769 12003 2 log file parallel write 32 16824 12003 2 gcs log flush sync 32 37 12003 2 gc current block 2-way 32 2026 12003 2 gc cr grant 2-way 32 3907 12003 2 LNS wait on SENDREQ 32 30301 12003 2 LNS ASYNC end of log 32 192953 12003 2 LGWR wait for redo copy 32 8 12003 3 log file sync 32 23 12003 3 log file parallel write 32 96 12003 3 gc current block 2-way 32 77 12003 3 gc cr grant 2-way 32 103 12003 3 LNS wait on SENDREQ 32 13 12003 3 LNS ASYNC end of log 32 607 12003 4 wait for scn ack 32 14 12003 4 log file sync 32 18527 12003 4 log file switch completion 32 48 12003 4 log file parallel write 32 101043 12003 4 gcs log flush sync 32 1 12003 4 gc current block 2-way 32 4158 12003 4 gc cr grant 2-way 32 19702 12003 4 LNS wait on SENDREQ 32 416297 12003 4 LNS ASYNC end of log 32 662123 12003 4 LGWR wait for redo copy 32 191 12003 1 log file sync 64 9 12003 1 log file parallel write 64 55 12003 1 gc current block 2-way 64 21 12003 1 gc cr grant 2-way 64 29 12003 1 LNS wait on ATTACH 64 1 12003 1 LNS ASYNC end of log 64 744 12003 2 wait for scn ack 64 4 12003 2 log file sync 64 3710 12003 2 log file switch completion 64 9 12003 2 log file parallel write 64 16183 12003 2 gcs log flush sync 64 21 12003 2 gc current block 2-way 64 1374 12003 2 gc cr grant 2-way 64 2911 12003 2 LNS wait on SENDREQ 64 813 12003 2 LNS wait on ATTACH 64 2 12003 2 LNS ASYNC end of log 64 118049 12003 2 LGWR wait for redo copy 64 2 12003 3 log file sync 64 21 12003 3 log file parallel write 64 83 12003 3 gc current block 2-way 64 16 12003 3 gc cr grant 2-way 64 43 12003 3 LNS wait on ATTACH 64 1 12003 3 LNS ASYNC end of log 64 897 12003 4 wait for scn ack 64 37 12003 4 log file sync 64 17245 12003 4 log file switch completion 64 114 12003 4 log file parallel write 64 103614 12003 4 gc current block 2-way 64 3027 12003 4 gc cr grant 2-way 64 15064 12003 4 LNS wait on SENDREQ 64 22790 12003 4 LNS wait on ATTACH 64 3 12003 4 LNS ASYNC end of log 64 521549 12003 4 LGWR wait for redo copy 64 129 12003 1 log file sync 128 1 12003 1 log file parallel write 128 23 12003 1 gc current block 2-way 128 2 12003 1 gc cr grant 2-way 128 12 12003 1 LNS ASYNC end of log 128 2507 12003 2 wait for scn ack 128 2 12003 2 log file sync 128 1146 12003 2 log file switch completion 128 6 12003 2 log file parallel write 128 4897 12003 2 gcs log flush sync 128 2 12003 2 gc current block 2-way 128 876 12003 2 gc cr grant 2-way 128 1784 12003 2 LNS wait on SENDREQ 128 42 12003 2 LNS ASYNC end of log 128 276842 12003 2 LGWR wait for redo copy 128 1 12003 3 log file parallel write 128 20 12003 3 gc current block 2-way 128 5 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 3 gc cr grant 2-way 128 4 12003 3 LNS ASYNC end of log 128 2885 12003 4 wait for scn ack 128 1 12003 4 log file sync 128 7034 12003 4 log file switch completion 128 101 12003 4 log file parallel write 128 31967 12003 4 gc current block 2-way 128 1742 12003 4 gc cr grant 2-way 128 7409 12003 4 LNS wait on SENDREQ 128 397 12003 4 LNS ASYNC end of log 128 1017134 12003 4 LGWR wait for redo copy 128 59 12003 1 log file parallel write 256 8 12003 1 gc current block 2-way 256 1 12003 1 gc cr grant 2-way 256 1 12003 1 LNS ASYNC end of log 256 1896 12003 2 log file sync 256 397 12003 2 log file switch completion 256 1 12003 2 log file parallel write 256 1270 12003 2 gc current block 2-way 256 234 12003 2 gc cr grant 2-way 256 202 12003 2 LNS wait on SENDREQ 256 52 12003 2 LNS ASYNC end of log 256 109549 12003 3 log file sync 256 1 12003 3 log file parallel write 256 11 12003 3 LNS ASYNC end of log 256 1532 12003 4 wait for scn ack 256 4 12003 4 log file sync 256 2718 12003 4 log file switch completion 256 25 12003 4 log file parallel write 256 8269 12003 4 gc current block 2-way 256 646 12003 4 gc cr grant 2-way 256 1257 12003 4 LNS wait on SENDREQ 256 1123 12003 4 LNS ASYNC end of log 256 477194 12003 4 LGWR wait for redo copy 256 7 12003 1 log file parallel write 512 4 12003 1 LNS ASYNC end of log 512 929 12003 2 log file sync 512 341 12003 2 log file parallel write 512 430 12003 2 gc current block 2-way 512 36 12003 2 gc cr grant 2-way 512 21 12003 2 LNS wait on SENDREQ 512 27 12003 2 LNS ASYNC end of log 512 63237 12003 3 log file parallel write 512 3 12003 3 LNS ASYNC end of log 512 741 12003 4 wait for scn ack 512 6 12003 4 log file sync 512 1000 12003 4 log file switch completion 512 1 12003 4 log file parallel write 512 2633 12003 4 gc current block 2-way 512 211 12003 4 gc cr grant 2-way 512 371 12003 4 LNS wait on SENDREQ 512 817 12003 4 LNS ASYNC end of log 512 220530 12003 1 log file parallel write 1024 3 12003 1 LNS ASYNC end of log 1024 1174 12003 2 log file sync 1024 66 12003 2 log file parallel write 1024 112 12003 2 gc current block 2-way 1024 21 12003 2 gc cr grant 2-way 1024 4 12003 2 LNS wait on SENDREQ 1024 8 12003 2 LNS ASYNC end of log 1024 49004 12003 3 log file parallel write 1024 1 12003 3 LNS ASYNC end of log 1024 950 12003 4 wait for scn ack 1024 5 12003 4 log file sync 1024 432 12003 4 log file switch completion 1024 1 12003 4 log file parallel write 1024 854 12003 4 gc current block 2-way 1024 69 12003 4 gc cr grant 2-way 1024 95 12003 4 LNS wait on SENDREQ 1024 219 12003 4 LNS ASYNC end of log 1024 159213 12003 1 log file parallel write 2048 2 12003 1 LNS wait on SENDREQ 2048 1 12003 2 log file sync 2048 20 12003 2 log file parallel write 2048 70 12003 2 gc current block 2-way 2048 6 12003 2 gc cr grant 2-way 2048 7 12003 2 LNS wait on SENDREQ 2048 6 12003 2 LNS ASYNC end of log 2048 1 12003 4 wait for scn ack 2048 5 12003 4 log file sync 2048 154 12003 4 log file switch completion 2048 1 12003 4 log file parallel write 2048 355 12003 4 gc current block 2-way 2048 20 12003 4 gc cr grant 2-way 2048 40 12003 4 LNS wait on SENDREQ 2048 113 12003 4 LNS ASYNC end of log 2048 22 12003 1 log file sync 4096 1 12003 1 LNS wait on SENDREQ 4096 2 12003 2 log file sync 4096 5 12003 2 log file parallel write 4096 9 12003 2 gc current block 2-way 4096 4 12003 2 gc cr grant 2-way 4096 6 12003 2 LNS wait on SENDREQ 4096 3 12003 3 LNS wait on SENDREQ 4096 1 12003 4 log file sync 4096 56 12003 4 log file parallel write 4096 78 12003 4 gc current block 2-way 4096 15 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12003 4 gc cr grant 2-way 4096 11 12003 4 LNS wait on SENDREQ 4096 67 12003 1 log file sync 8192 1 12003 1 log file parallel write 8192 1 12003 1 LNS wait on SENDREQ 8192 1 12003 2 log file sync 8192 3 12003 2 log file parallel write 8192 1 12003 2 gc current block 2-way 8192 1 12003 2 gc cr grant 2-way 8192 1 12003 2 LNS wait on SENDREQ 8192 2 12003 4 log file sync 8192 8 12003 4 log file parallel write 8192 2 12003 4 gc current block 2-way 8192 8 12003 4 gc cr grant 2-way 8192 36 12003 4 LNS wait on SENDREQ 8192 63 12003 1 log file sync 16384 3 12003 1 log file parallel write 16384 1 12003 1 LNS wait on SENDREQ 16384 4 12003 2 log file sync 16384 1 12003 2 log file parallel write 16384 1 12003 2 gc cr grant 2-way 16384 9 12003 2 LNS wait on SENDREQ 16384 5 12003 3 LNS wait on SENDREQ 16384 1 12003 4 log file parallel write 16384 1 12003 4 gc current block 2-way 16384 12 12003 4 gc cr grant 2-way 16384 53 12003 4 LNS wait on SENDREQ 16384 35 12003 1 LNS wait on SENDREQ 32768 1 12003 2 gc current block 2-way 32768 3 12003 2 gc cr grant 2-way 32768 7 12003 2 LNS wait on SENDREQ 32768 3 12003 3 LNS wait on SENDREQ 32768 1 12003 4 log file sync 32768 1 12003 4 gc current block 2-way 32768 13 12003 4 gc cr grant 2-way 32768 53 12003 4 LNS wait on SENDREQ 32768 17 12003 2 gc current block 2-way 65536 13 12003 2 gc cr grant 2-way 65536 29 12003 4 gc current block 2-way 65536 16 12003 4 gc cr grant 2-way 65536 76 12003 4 LNS wait on SENDREQ 65536 8 12003 2 gc current block 2-way 131072 26 12003 2 gc cr grant 2-way 131072 95 12003 4 gc current block 2-way 131072 33 12003 4 gc cr grant 2-way 131072 99 12003 2 gc current block 2-way 262144 18 12003 2 gc cr grant 2-way 262144 52 12003 4 gc current block 2-way 262144 24 12003 4 gc cr grant 2-way 262144 111 12003 4 gc cr grant 2-way 524288 9 12004 1 log file sync 1 711 12004 1 log file parallel write 1 15558 12004 1 gcs log flush sync 1 416 12004 1 gc current block 2-way 1 144362 12004 1 gc cr grant 2-way 1 200669 12004 1 LNS wait on SENDREQ 1 14573 12004 1 LNS wait on LGWR 1 1 12004 1 LNS wait on DETACH 1 1 12004 1 LNS ASYNC end of log 1 3197 12004 1 LGWR-LNS wait on channel 1 1 12004 1 LGWR wait for redo copy 1 1445 12004 2 wait for scn ack 1 15 12004 2 log file sync 1 356242 12004 2 log file parallel write 1 1274395 12004 2 gcs log flush sync 1 204255 12004 2 gc current block 2-way 1 2838978 12004 2 gc cr grant 2-way 1 3817195 12004 2 LNS wait on SENDREQ 1 1310095 12004 2 LNS wait on LGWR 1 1 12004 2 LNS wait on DETACH 1 1 12004 2 LNS ASYNC end of log 1 205999 12004 2 LGWR wait for redo copy 1 131716 12004 3 log file sync 1 995 12004 3 log file parallel write 1 13257 12004 3 gcs log flush sync 1 261 12004 3 gc current block 2-way 1 95380 12004 3 gc cr grant 2-way 1 209814 12004 3 LNS wait on SENDREQ 1 12773 12004 3 LNS wait on LGWR 1 1 12004 3 LNS wait on DETACH 1 1 12004 3 LNS ASYNC end of log 1 3523 12004 3 LGWR-LNS wait on channel 1 1 12004 3 LGWR wait for redo copy 1 540 12004 4 wait for scn ack 1 8 12004 4 log file sync 1 1170995 12004 4 log file switch completion 1 3 12004 4 log file parallel write 1 5314865 12004 4 gcs log flush sync 1 1235869 12004 4 gc current block 2-way 1 7503633 12004 4 gc cr grant 2-way 1 17444480 12004 4 LNS wait on SENDREQ 1 5489586 12004 4 LNS wait on LGWR 1 1 12004 4 LNS wait on DETACH 1 1 12004 4 LNS ASYNC end of log 1 892902 12004 4 LGWR-LNS wait on channel 1 1 12004 4 LGWR wait for redo copy 1 567267 12004 1 log file sync 2 36 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 1 log file parallel write 2 386 12004 1 gcs log flush sync 2 44 12004 1 gc current block 2-way 2 167 12004 1 gc cr grant 2-way 2 328 12004 1 LNS wait on SENDREQ 2 211 12004 1 LNS ASYNC end of log 2 519 12004 2 wait for scn ack 2 10 12004 2 log file sync 2 24501 12004 2 log file parallel write 2 45206 12004 2 gcs log flush sync 2 11741 12004 2 gc current block 2-way 2 15521 12004 2 gc cr grant 2-way 2 21366 12004 2 LNS wait on SENDREQ 2 28088 12004 2 LNS wait on DETACH 2 1 12004 2 LNS ASYNC end of log 2 66959 12004 2 LGWR wait for redo copy 2 1343 12004 3 log file sync 2 417 12004 3 log file parallel write 2 1182 12004 3 gcs log flush sync 2 12 12004 3 gc current block 2-way 2 271 12004 3 gc cr grant 2-way 2 425 12004 3 LNS wait on SENDREQ 2 181 12004 3 LNS ASYNC end of log 2 305 12004 4 wait for scn ack 2 22 12004 4 log file sync 2 122308 12004 4 log file switch completion 2 4 12004 4 log file parallel write 2 320760 12004 4 gcs log flush sync 2 56033 12004 4 gc current block 2-way 2 26838 12004 4 gc cr grant 2-way 2 85488 12004 4 LNS wait on SENDREQ 2 106112 12004 4 LNS wait on DETACH 2 2 12004 4 LNS ASYNC end of log 2 640377 12004 4 LGWR wait for redo copy 2 2676 12004 1 log file sync 4 6 12004 1 log file parallel write 4 240 12004 1 gcs log flush sync 4 30 12004 1 gc current block 2-way 4 136 12004 1 gc cr grant 2-way 4 217 12004 1 LNS wait on SENDREQ 4 278 12004 1 LNS ASYNC end of log 4 739 12004 2 wait for scn ack 4 10 12004 2 log file sync 4 13936 12004 2 log file parallel write 4 49517 12004 2 gcs log flush sync 4 7097 12004 2 gc current block 2-way 4 13969 12004 2 gc cr grant 2-way 4 11441 12004 2 LNS wait on SENDREQ 4 14662 12004 2 LNS ASYNC end of log 4 140190 12004 2 LGWR wait for redo copy 4 354 12004 3 log file sync 4 548 12004 3 log file parallel write 4 208 12004 3 gcs log flush sync 4 4 12004 3 gc current block 2-way 4 227 12004 3 gc cr grant 2-way 4 352 12004 3 LNS wait on SENDREQ 4 148 12004 3 LNS ASYNC end of log 4 416 12004 4 wait for scn ack 4 107 12004 4 log file sync 4 60019 12004 4 log file switch completion 4 1 12004 4 log file parallel write 4 545815 12004 4 gcs log flush sync 4 34431 12004 4 gc current block 2-way 4 12575 12004 4 gc cr grant 2-way 4 46107 12004 4 LNS wait on SENDREQ 4 70427 12004 4 LNS ASYNC end of log 4 487506 12004 4 LGWR-LNS wait on channel 4 1 12004 4 LGWR wait for redo copy 4 825 12004 1 log file sync 8 6 12004 1 log file parallel write 8 68 12004 1 gcs log flush sync 8 20 12004 1 gc current block 2-way 8 94 12004 1 gc cr grant 2-way 8 163 12004 1 LNS wait on SENDREQ 8 243 12004 1 LNS ASYNC end of log 8 709 12004 1 LGWR-LNS wait on channel 8 1 12004 2 wait for scn ack 8 4 12004 2 log file sync 8 6280 12004 2 log file parallel write 8 9626 12004 2 gcs log flush sync 8 5068 12004 2 gc current block 2-way 8 11526 12004 2 gc cr grant 2-way 8 7517 12004 2 LNS wait on SENDREQ 8 16723 12004 2 LNS ASYNC end of log 8 120314 12004 2 LGWR wait for redo copy 8 27 12004 3 log file sync 8 26 12004 3 log file parallel write 8 62 12004 3 gcs log flush sync 8 6 12004 3 gc current block 2-way 8 149 12004 3 gc cr grant 2-way 8 221 12004 3 LNS wait on SENDREQ 8 159 12004 3 LNS ASYNC end of log 8 798 12004 3 LGWR-LNS wait on channel 8 1 12004 4 wait for scn ack 8 46 12004 4 log file sync 8 27503 12004 4 log file switch completion 8 3 12004 4 log file parallel write 8 65515 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 4 gcs log flush sync 8 24781 12004 4 gc current block 2-way 8 7559 12004 4 gc cr grant 2-way 8 29403 12004 4 LNS wait on SENDREQ 8 73704 12004 4 LNS ASYNC end of log 8 487362 12004 4 LGWR wait for redo copy 8 424 12004 1 log file sync 16 3 12004 1 log file parallel write 16 77 12004 1 gcs log flush sync 16 23 12004 1 gc current block 2-way 16 65 12004 1 gc cr grant 2-way 16 126 12004 1 LNS wait on SENDREQ 16 301 12004 1 LNS ASYNC end of log 16 536 12004 1 LGWR-LNS wait on channel 16 188 12004 2 wait for scn ack 16 5 12004 2 log file sync 16 4444 12004 2 log file switch completion 16 1 12004 2 log file parallel write 16 11388 12004 2 gcs log flush sync 16 9204 12004 2 gc current block 2-way 16 5618 12004 2 gc cr grant 2-way 16 5889 12004 2 LNS wait on SENDREQ 16 41987 12004 2 LNS ASYNC end of log 16 74045 12004 2 LGWR wait for redo copy 16 7 12004 3 log file sync 16 17 12004 3 log file parallel write 16 76 12004 3 gcs log flush sync 16 14 12004 3 gc current block 2-way 16 147 12004 3 gc cr grant 2-way 16 176 12004 3 LNS wait on SENDREQ 16 1137 12004 3 LNS ASYNC end of log 16 386 12004 3 LGWR-LNS wait on channel 16 156 12004 4 wait for scn ack 16 9 12004 4 log file sync 16 20299 12004 4 log file switch completion 16 9 12004 4 log file parallel write 16 64947 12004 4 gcs log flush sync 16 41969 12004 4 gc current block 2-way 16 5749 12004 4 gc cr grant 2-way 16 24454 12004 4 LNS wait on SENDREQ 16 285918 12004 4 LNS ASYNC end of log 16 353699 12004 4 LGWR-LNS wait on channel 16 85 12004 4 LGWR wait for redo copy 16 283 12004 1 log file sync 32 2 12004 1 log file parallel write 32 98 12004 1 gc current block 2-way 32 58 12004 1 gc cr grant 2-way 32 99 12004 1 LNS wait on SENDREQ 32 22 12004 1 LNS ASYNC end of log 32 1241 12004 2 wait for scn ack 32 10 12004 2 log file sync 32 3769 12004 2 log file parallel write 32 16846 12004 2 gcs log flush sync 32 37 12004 2 gc current block 2-way 32 2071 12004 2 gc cr grant 2-way 32 3911 12004 2 LNS wait on SENDREQ 32 30317 12004 2 LNS ASYNC end of log 32 193069 12004 2 LGWR wait for redo copy 32 8 12004 3 log file sync 32 29 12004 3 log file parallel write 32 117 12004 3 gc current block 2-way 32 111 12004 3 gc cr grant 2-way 32 109 12004 3 LNS wait on SENDREQ 32 25 12004 3 LNS ASYNC end of log 32 722 12004 4 wait for scn ack 32 14 12004 4 log file sync 32 18528 12004 4 log file switch completion 32 48 12004 4 log file parallel write 32 101055 12004 4 gcs log flush sync 32 1 12004 4 gc current block 2-way 32 4158 12004 4 gc cr grant 2-way 32 19702 12004 4 LNS wait on SENDREQ 32 416298 12004 4 LNS ASYNC end of log 32 662210 12004 4 LGWR wait for redo copy 32 191 12004 1 log file sync 64 12 12004 1 log file parallel write 64 69 12004 1 gc current block 2-way 64 26 12004 1 gc cr grant 2-way 64 39 12004 1 LNS wait on ATTACH 64 1 12004 1 LNS ASYNC end of log 64 896 12004 2 wait for scn ack 64 4 12004 2 log file sync 64 3710 12004 2 log file switch completion 64 9 12004 2 log file parallel write 64 16196 12004 2 gcs log flush sync 64 21 12004 2 gc current block 2-way 64 1394 12004 2 gc cr grant 2-way 64 2914 12004 2 LNS wait on SENDREQ 64 813 12004 2 LNS wait on ATTACH 64 2 12004 2 LNS ASYNC end of log 64 118207 12004 2 LGWR wait for redo copy 64 2 12004 3 log file sync 64 24 12004 3 log file parallel write 64 96 12004 3 gc current block 2-way 64 31 12004 3 gc cr grant 2-way 64 45 12004 3 LNS wait on ATTACH 64 1 12004 3 LNS ASYNC end of log 64 1046 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 4 wait for scn ack 64 37 12004 4 log file sync 64 17245 12004 4 log file switch completion 64 114 12004 4 log file parallel write 64 103624 12004 4 gc current block 2-way 64 3027 12004 4 gc cr grant 2-way 64 15064 12004 4 LNS wait on SENDREQ 64 22790 12004 4 LNS wait on ATTACH 64 3 12004 4 LNS ASYNC end of log 64 521689 12004 4 LGWR wait for redo copy 64 129 12004 1 log file sync 128 3 12004 1 log file parallel write 128 28 12004 1 gc current block 2-way 128 3 12004 1 gc cr grant 2-way 128 15 12004 1 LNS ASYNC end of log 128 2748 12004 2 wait for scn ack 128 2 12004 2 log file sync 128 1146 12004 2 log file switch completion 128 6 12004 2 log file parallel write 128 4898 12004 2 gcs log flush sync 128 2 12004 2 gc current block 2-way 128 883 12004 2 gc cr grant 2-way 128 1784 12004 2 LNS wait on SENDREQ 128 42 12004 2 LNS ASYNC end of log 128 277227 12004 2 LGWR wait for redo copy 128 1 12004 3 log file parallel write 128 22 12004 3 gc current block 2-way 128 7 12004 3 gc cr grant 2-way 128 4 12004 3 LNS ASYNC end of log 128 3208 12004 4 wait for scn ack 128 1 12004 4 log file sync 128 7034 12004 4 log file switch completion 128 101 12004 4 log file parallel write 128 31968 12004 4 gc current block 2-way 128 1743 12004 4 gc cr grant 2-way 128 7409 12004 4 LNS wait on SENDREQ 128 397 12004 4 LNS ASYNC end of log 128 1017477 12004 4 LGWR wait for redo copy 128 59 12004 1 log file parallel write 256 8 12004 1 gc current block 2-way 256 1 12004 1 gc cr grant 2-way 256 1 12004 1 LNS ASYNC end of log 256 2252 12004 2 log file sync 256 397 12004 2 log file switch completion 256 1 12004 2 log file parallel write 256 1270 12004 2 gc current block 2-way 256 234 12004 2 gc cr grant 2-way 256 202 12004 2 LNS wait on SENDREQ 256 52 12004 2 LNS ASYNC end of log 256 109933 12004 3 log file sync 256 1 12004 3 log file parallel write 256 11 12004 3 LNS ASYNC end of log 256 1837 12004 4 wait for scn ack 256 4 12004 4 log file sync 256 2718 12004 4 log file switch completion 256 25 12004 4 log file parallel write 256 8269 12004 4 gc current block 2-way 256 646 12004 4 gc cr grant 2-way 256 1257 12004 4 LNS wait on SENDREQ 256 1123 12004 4 LNS ASYNC end of log 256 477549 12004 4 LGWR wait for redo copy 256 7 12004 1 log file parallel write 512 4 12004 1 LNS ASYNC end of log 512 1304 12004 2 log file sync 512 341 12004 2 log file parallel write 512 430 12004 2 gc current block 2-way 512 36 12004 2 gc cr grant 2-way 512 21 12004 2 LNS wait on SENDREQ 512 27 12004 2 LNS ASYNC end of log 512 63610 12004 3 log file parallel write 512 3 12004 3 LNS wait on SENDREQ 512 1 12004 3 LNS ASYNC end of log 512 1095 12004 4 wait for scn ack 512 6 12004 4 log file sync 512 1000 12004 4 log file switch completion 512 1 12004 4 log file parallel write 512 2633 12004 4 gc current block 2-way 512 211 12004 4 gc cr grant 2-way 512 371 12004 4 LNS wait on SENDREQ 512 817 12004 4 LNS ASYNC end of log 512 220973 12004 1 log file parallel write 1024 3 12004 1 LNS ASYNC end of log 1024 1917 12004 2 log file sync 1024 66 12004 2 log file parallel write 1024 112 12004 2 gc current block 2-way 1024 21 12004 2 gc cr grant 2-way 1024 4 12004 2 LNS wait on SENDREQ 1024 8 12004 2 LNS ASYNC end of log 1024 49747 12004 3 log file parallel write 1024 1 12004 3 LNS wait on SENDREQ 1024 1 12004 3 LNS ASYNC end of log 1024 1702 12004 4 wait for scn ack 1024 5 12004 4 log file sync 1024 432 12004 4 log file switch completion 1024 1 12004 4 log file parallel write 1024 854 12004 4 gc current block 2-way 1024 69 12004 4 gc cr grant 2-way 1024 95 SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT ---------- ---- ---------------------------------------- --------------- ---------- 12004 4 LNS wait on SENDREQ 1024 219 12004 4 LNS ASYNC end of log 1024 159927 12004 1 log file parallel write 2048 2 12004 1 LNS wait on SENDREQ 2048 2 12004 2 log file sync 2048 20 12004 2 log file parallel write 2048 70 12004 2 gc current block 2-way 2048 6 12004 2 gc cr grant 2-way 2048 7 12004 2 LNS wait on SENDREQ 2048 8 12004 2 LNS ASYNC end of log 2048 1 12004 4 wait for scn ack 2048 5 12004 4 log file sync 2048 154 12004 4 log file switch completion 2048 1 12004 4 log file parallel write 2048 355 12004 4 gc current block 2-way 2048 20 12004 4 gc cr grant 2-way 2048 40 12004 4 LNS wait on SENDREQ 2048 113 12004 4 LNS ASYNC end of log 2048 22 12004 1 log file sync 4096 1 12004 1 LNS wait on SENDREQ 4096 3 12004 2 log file sync 4096 5 12004 2 log file parallel write 4096 9 12004 2 gc current block 2-way 4096 4 12004 2 gc cr grant 2-way 4096 6 12004 2 LNS wait on SENDREQ 4096 4 12004 3 LNS wait on SENDREQ 4096 2 12004 4 log file sync 4096 56 12004 4 log file parallel write 4096 78 12004 4 gc current block 2-way 4096 15 12004 4 gc cr grant 2-way 4096 11 12004 4 LNS wait on SENDREQ 4096 70 12004 1 log file sync 8192 1 12004 1 log file parallel write 8192 1 12004 1 LNS wait on SENDREQ 8192 2 12004 2 log file sync 8192 3 12004 2 log file parallel write 8192 1 12004 2 gc current block 2-way 8192 1 12004 2 gc cr grant 2-way 8192 1 12004 2 LNS wait on SENDREQ 8192 2 12004 4 log file sync 8192 8 12004 4 log file parallel write 8192 2 12004 4 gc current block 2-way 8192 8 12004 4 gc cr grant 2-way 8192 36 12004 4 LNS wait on SENDREQ 8192 63 12004 1 log file sync 16384 3 12004 1 log file parallel write 16384 1 12004 1 LNS wait on SENDREQ 16384 4 12004 2 log file sync 16384 1 12004 2 log file parallel write 16384 1 12004 2 gc cr grant 2-way 16384 9 12004 2 LNS wait on SENDREQ 16384 5 12004 3 LNS wait on SENDREQ 16384 1 12004 4 log file parallel write 16384 1 12004 4 gc current block 2-way 16384 12 12004 4 gc cr grant 2-way 16384 53 12004 4 LNS wait on SENDREQ 16384 35 12004 1 LNS wait on SENDREQ 32768 1 12004 2 gc current block 2-way 32768 3 12004 2 gc cr grant 2-way 32768 7 12004 2 LNS wait on SENDREQ 32768 3 12004 3 LNS wait on SENDREQ 32768 1 12004 4 log file sync 32768 1 12004 4 gc current block 2-way 32768 13 12004 4 gc cr grant 2-way 32768 53 12004 4 LNS wait on SENDREQ 32768 17 12004 2 gc current block 2-way 65536 13 12004 2 gc cr grant 2-way 65536 29 12004 4 gc current block 2-way 65536 16 12004 4 gc cr grant 2-way 65536 76 12004 4 LNS wait on SENDREQ 65536 8 12004 2 gc current block 2-way 131072 26 12004 2 gc cr grant 2-way 131072 95 12004 4 gc current block 2-way 131072 33 12004 4 gc cr grant 2-way 131072 99 12004 2 gc current block 2-way 262144 18 12004 2 gc cr grant 2-way 262144 52 12004 4 gc current block 2-way 262144 24 12004 4 gc cr grant 2-way 262144 111 12004 4 gc cr grant 2-way 524288 9 ASH DETAILS FOR WORST MINUTES: APPROACH: If you cannot determine the problem from the data above, you may need to look at the details of what each session is doing during each 'bad' snap. Most likely you will want to note the times of the high log file sync waits, look at what LGWR is doing at those times, and go from there... SAMPLE_TIME INST SESSION_ID PROGRAM EVENT TIME_WAITED ------------------------- ---- ---------- --------------------------------------------- ------------------------------ ----------- P1 P2 P3 ---------------------------------------- ---------------------------------------- ---------------------------------------- 01-OCT-12 01.11.02.480 AM 2 982 sqlplus@racnode1.us.oracle.com (TNS V1-V3) library cache: mutex X 10.866 idn: 891844779 value: 5050881540096 where: 4 01-OCT-12 01.11.02.480 AM 2 1172 sqlplus@racnode1.us.oracle.com (TNS V1-V3) library cache: mutex X 10.860 idn: 891844779 value: 5050881540096 where: 4 01-OCT-12 01.11.12.521 AM 2 982 sqlplus@racnode1.us.oracle.com (TNS V1-V3) library cache: mutex X 11.818 idn: 923095243 value: 5330054414336 where: 106 01-OCT-12 01.11.13.521 AM 2 1368 sqlplus@racnode1.us.oracle.com (TNS V1-V3) log file sync .807 buffer#: 89280 sync scn: 3422961631 : 0 01-OCT-12 01.11.13.521 AM 2 1431 oracle@racnode1.us.oracle.com (LGWR) log file parallel write .693 files: 2 blocks: 14 requests: 2 01-OCT-12 01.11.15.521 AM 2 916 sqlplus@racnode1.us.oracle.com (TNS V1-V3) library cache: mutex X 11.313 idn: 2423010972 value: 3375844294656 where: 1 01-OCT-12 01.11.24.541 AM 2 3 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.108 type|mode: 1230372869 id1: 1398361667 id2: 10 01-OCT-12 01.11.24.541 AM 2 7 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.304 type|mode: 1230372869 id1: 1398361667 id2: 6 01-OCT-12 01.11.24.541 AM 2 8 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 104.922 type|mode: 1230372869 id1: 1398361667 id2: 4 01-OCT-12 01.11.24.541 AM 2 71 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.354 type|mode: 1230372869 id1: 1398361667 id2: 41 01-OCT-12 01.11.24.541 AM 2 72 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.061 type|mode: 1230372869 id1: 1280262987 id2: 47 01-OCT-12 01.11.24.541 AM 2 136 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.180 type|mode: 1230372869 id1: 1398361667 id2: 33 01-OCT-12 01.11.24.541 AM 2 137 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 104.572 type|mode: 1230372869 id1: 1398361667 id2: 11 01-OCT-12 01.11.24.541 AM 2 200 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.052 type|mode: 1230372869 id1: 1280262987 id2: 39 01-OCT-12 01.11.24.541 AM 2 203 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.968 type|mode: 1230372869 id1: 1398361667 id2: 59 01-OCT-12 01.11.24.541 AM 2 266 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.425 type|mode: 1230372869 id1: 1280262987 id2: 1 01-OCT-12 01.11.24.541 AM 2 268 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.720 type|mode: 1230372869 id1: 1280262987 id2: 64 01-OCT-12 01.11.24.541 AM 2 331 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.076 type|mode: 1230372869 id1: 1398361667 id2: 46 01-OCT-12 01.11.24.541 AM 2 332 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.348 type|mode: 1230372869 id1: 1280262987 id2: 38 01-OCT-12 01.11.24.541 AM 2 395 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.405 type|mode: 1230372869 id1: 1280262987 id2: 29 01-OCT-12 01.11.24.541 AM 2 396 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.451 type|mode: 1230372869 id1: 1280262987 id2: 34 01-OCT-12 01.11.24.541 AM 2 460 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.194 type|mode: 1230372869 id1: 1280262987 id2: 60 01-OCT-12 01.11.24.541 AM 2 465 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.000 type|mode: 1230372869 id1: 1280262987 id2: 62 01-OCT-12 01.11.24.541 AM 2 525 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.414 type|mode: 1230372869 id1: 1398361667 id2: 30 01-OCT-12 01.11.24.541 AM 2 526 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 230.909 channel context: 18464876448 channel handle: 18534671064 broadcast message: 17527392560 01-OCT-12 01.11.24.541 AM 2 590 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.129 type|mode: 1230372869 id1: 1280262987 id2: 19 01-OCT-12 01.11.24.541 AM 2 591 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 223.551 channel context: 18464876448 channel handle: 18534671864 broadcast message: 17601837016 01-OCT-12 01.11.24.541 AM 2 592 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.286 type|mode: 1230372869 id1: 1280262987 id2: 35 01-OCT-12 01.11.24.541 AM 2 655 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.170 type|mode: 1230372869 id1: 1280262987 id2: 12 01-OCT-12 01.11.24.541 AM 2 656 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 221.005 channel context: 18464876448 channel handle: 18534672664 broadcast message: 17494114856 01-OCT-12 01.11.24.541 AM 2 720 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 223.817 channel context: 18464876448 channel handle: 18534673464 broadcast message: 17601836120 01-OCT-12 01.11.24.541 AM 2 722 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.205 type|mode: 1230372869 id1: 1280262987 id2: 58 SAMPLE_TIME INST SESSION_ID PROGRAM EVENT TIME_WAITED ------------------------- ---- ---------- --------------------------------------------- ------------------------------ ----------- P1 P2 P3 ---------------------------------------- ---------------------------------------- ---------------------------------------- 01-OCT-12 01.11.24.541 AM 2 786 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 216.092 channel context: 18464876448 channel handle: 18534674288 broadcast message: 17601840632 01-OCT-12 01.11.24.541 AM 2 788 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.342 type|mode: 1230372869 id1: 1280262987 id2: 37 01-OCT-12 01.11.24.541 AM 2 848 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.420 type|mode: 1230372869 id1: 1398361667 id2: 50 01-OCT-12 01.11.24.541 AM 2 849 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 228.816 channel context: 18464876448 channel handle: 18534637200 broadcast message: 17601841544 01-OCT-12 01.11.24.541 AM 2 851 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 216.148 channel context: 18464876448 channel handle: 18534675088 broadcast message: 17601839736 01-OCT-12 01.11.24.541 AM 2 914 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.151 type|mode: 1230372869 id1: 1280262987 id2: 13 01-OCT-12 01.11.24.541 AM 2 916 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 214.348 channel context: 18464876448 channel handle: 18534675888 broadcast message: 17527270144 01-OCT-12 01.11.24.541 AM 2 917 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 104.740 type|mode: 1230372869 id1: 1280262987 id2: 5 01-OCT-12 01.11.24.541 AM 2 982 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 211.401 channel context: 18464876448 channel handle: 18534676688 broadcast message: 17527399792 01-OCT-12 01.11.24.541 AM 2 983 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.622 type|mode: 1230372869 id1: 1280262987 id2: 17 01-OCT-12 01.11.24.541 AM 2 1044 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.454 type|mode: 1230372869 id1: 1280262987 id2: 25 01-OCT-12 01.11.24.541 AM 2 1046 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.674 type|mode: 1230372869 id1: 1398361667 id2: 51 01-OCT-12 01.11.24.541 AM 2 1047 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 213.379 channel context: 18464876448 channel handle: 18534677512 broadcast message: 17638472256 01-OCT-12 01.11.24.541 AM 2 1110 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.718 type|mode: 1230372869 id1: 1280262987 id2: 42 01-OCT-12 01.11.24.541 AM 2 1111 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 215.866 channel context: 18464876448 channel handle: 18534639624 broadcast message: 17494115752 01-OCT-12 01.11.24.541 AM 2 1112 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 227.831 channel context: 18464876448 channel handle: 18534678312 broadcast message: 17601837928 01-OCT-12 01.11.24.541 AM 2 1172 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 211.303 channel context: 18464876448 channel handle: 18534679112 broadcast message: 17527393472 01-OCT-12 01.11.24.541 AM 2 1176 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 208.539 channel context: 18464876448 channel handle: 18534641624 broadcast message: 17638474960 01-OCT-12 01.11.24.541 AM 2 1177 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.748 type|mode: 1230372869 id1: 1280262987 id2: 22 01-OCT-12 01.11.24.541 AM 2 1241 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 209.399 channel context: 18464876448 channel handle: 18534679912 broadcast message: 17527391664 01-OCT-12 01.11.24.541 AM 2 1242 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.475 type|mode: 1230372869 id1: 1398361667 id2: 8 01-OCT-12 01.11.24.541 AM 2 1307 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.285 type|mode: 1230372869 id1: 1280262987 id2: 2 01-OCT-12 01.11.24.541 AM 2 1308 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 203.325 channel context: 18464876448 channel handle: 18534680736 broadcast message: 17601834312 01-OCT-12 01.11.24.541 AM 2 1309 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.436 type|mode: 1230372869 id1: 1398361667 id2: 23 01-OCT-12 01.11.24.541 AM 2 1368 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 204.392 channel context: 18464876448 channel handle: 18534681536 broadcast message: 17638615688 01-OCT-12 01.11.24.541 AM 2 1369 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.719 type|mode: 1230372869 id1: 1280262987 id2: 14 01-OCT-12 01.11.24.541 AM 2 1371 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.093 type|mode: 1230372869 id1: 1398361667 id2: 48 01-OCT-12 01.11.24.541 AM 2 1372 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.045 type|mode: 1230372869 id1: 1280262987 id2: 52 01-OCT-12 01.11.24.541 AM 2 1431 oracle@racnode1.us.oracle.com (LGWR) log file parallel write .331 files: 2 blocks: 4 requests: 2 01-OCT-12 01.11.24.541 AM 2 1436 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 202.088 channel context: 18464876448 channel handle: 18534682336 broadcast message: 17601842440 01-OCT-12 01.11.24.541 AM 2 1437 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 106.166 type|mode: 1230372869 id1: 1280262987 id2: 44 01-OCT-12 01.11.24.541 AM 2 1439 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.365 SAMPLE_TIME INST SESSION_ID PROGRAM EVENT TIME_WAITED ------------------------- ---- ---------- --------------------------------------------- ------------------------------ ----------- P1 P2 P3 ---------------------------------------- ---------------------------------------- ---------------------------------------- type|mode: 1230372869 id1: 1398361667 id2: 24 01-OCT-12 01.11.24.541 AM 2 1502 sqlplus@racnode1.us.oracle.com (TNS V1-V3) DFS lock handle 105.389 type|mode: 1230372869 id1: 1280262987 id2: 16 01-OCT-12 01.11.55.591 AM 2 1496 oracle@racnode1.us.oracle.com (CKPT) control file parallel write 13.751 files: 2 block#: 4 requests: 2 01-OCT-12 01.11.58.591 AM 2 1496 oracle@racnode1.us.oracle.com (CKPT) control file parallel write 38.408 files: 2 block#: 4 requests: 2 02-OCT-12 06.00.10.897 AM 2 1239 oracle@racnode1.us.oracle.com (M000) log file sync 4.308 buffer#: 35003 sync scn: 3426312105 : 0 02-OCT-12 06.00.10.897 AM 2 1431 oracle@racnode1.us.oracle.com (LGWR) log file parallel write 4.088 files: 2 blocks: 2458 requests: 2 02-OCT-12 06.00.26.917 AM 2 588 oracle@racnode1.us.oracle.com (DW00) Datapump dump file I/O 3.380 count: 1 intr: 256 timeout: 4294967295 02-OCT-12 06.00.49.947 AM 2 1496 oracle@racnode1.us.oracle.com (CKPT) control file parallel write 8.079 files: 2 block#: 4 requests: 2 09-OCT-12 12.43.30.714 AM 2 652 sqlplus@racnode1.us.oracle.com (TNS V1-V3) log file sync 999.805 buffer#: 122391 sync scn: 3431114291 : 0 09-OCT-12 12.43.30.714 AM 2 1431 oracle@racnode1.us.oracle.com (LGWR) log file parallel write 1000.738 files: 2 blocks: 4 requests: 2 09-OCT-12 12.43.52.633 AM 1 293 oracle@dmorldb05.us.oracle.com (M001) CSS operation: action 4.057 function_id: 65 : 0 : 0 TIME ----------------------- Oct10 13:07:22 References NOTE:34592.1 - WAITEVENT: "log file sync" Reference Note
NOTE:857576.1 - How to Reduce Waits on 'Log File Sync'
