Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)

发布时间：2020-08-05 10:34:10 来源：ITPUB博客阅读：205 作者：sqysl 栏目：关系型数据库

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_hh34mi') 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_hh34mi') 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_hh34mi')
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_hh34mi') 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_hh34mi'), 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_hh34mi') 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_hh34mi') in (select to_char(sample_time,'Mondd_hh34mi')
from gv$active_session_history
where event = 'log file sync'
group by to_char(sample_time,'Mondd_hh34mi'), 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_hh34mi'), 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_hh34mi') BEGIN,
to_char(dhs.end_interval_time,'Mondd_hh34mi') 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_hh34mi') in (select
to_char(sample_time,'Mondd_hh34mi')
from gv$active_session_history
where event = 'log file sync'
group by to_char(sample_time,'Mondd_hh34mi'), 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 hh34: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'

向AI问一下细节

Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)

猜你喜欢

最新资讯

相关推荐

相关标签