Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql) 01/31 Update SLTechnology News&Howtos

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

2025-01-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

The article from: http://m.blog.itpub.net/31393455/viewspace-2130875/

Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql) (document 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 & & threshold

Order by 1pr 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 2murway.'

'gc buffer busy','gc current block 2murway') 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 2murway.'

'gc buffer busy','gc current block 2murway')

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 (100per second)

PROMPT 11.1: "redo write broadcast ack time" in centiseconds (100per 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 magic decode name,'redo write time',value*10

'redo write broadcast ack time',value*10)

'11.2 magic 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 >

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)

"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)

"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 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 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 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 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 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 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 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 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 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 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 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 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 writes 1427035

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2982 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 2982 sqlplus@racnode1.us.oracle.com (TNS V1-V3) library cache: mutex X 11.818

Idn: 923095243 value: 5330054414336 where: 10601-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 2916 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 23 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 28 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 2200 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 2203 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 2266 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 2268 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 2331 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 2332 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 2395 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 2396 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 2460 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 2465 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 2525 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 2526 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 2590 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 2591 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 2592 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 2656 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 2720 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 2722 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 2788 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 2848 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 2849 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 2851 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 2914 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 2916 sqlplus@racnode1.us.oracle.com (TNS V1-V3) reliable message 214.348

Channel context: 18464876448 channel handle: 18534675888 broadcast message: 175270144 01-OCT-12 01.11.24.541 AM 2917 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 2982 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 2983 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 21309 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 21437 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 2588 oracle@racnode1.us.oracle.com (DW00) Datapump dump file I am 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 2652 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'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.