내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.18.0.0
방법 : 오라클 19c log file sync 대기 이벤트 발생 시 정보 수집 쿼리
오라클 사용중 log file sync 이벤트가 발생했을때 이 스크립트를 실행해 결과를
sr에 업로드하면 보다 빠르게 분석이 가능함
스크립트 안에 있는 optimizer_features_enable 파라미터는 필요에 따라 수정가능
스크립트(lfsdiag.sql)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
|
$ vi lfsdiag.sql
-- NAME: LFSDIAG.SQL
-- ------------------------------------------------------------------------
-- AUTHOR: - 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_<timestamp>.out in your local directory.
-- value for optimizer_features_enable may be modified as needed (4/19/18)
set echo off
set feedback off
column timecol new_value timestamp
column spool_extension new_value suffix
select to_char(sysdate,'Mondd_hh24mi') timecol,
'.out' spool_extension from sys.dual;
column output new_value dbname
select value || '_' output
from v$parameter where name = 'db_name';
spool lfsdiag_&&dbname&×tamp&&suffix
set trim on
set trims on
set lines 140
set pages 100
set verify off
alter session set optimizer_features_enable = '10.2.0.4';
PROMPT LFSDIAG DATA FOR &&dbname&×tamp
PROMPT Note: All timings are in milliseconds (1000 milliseconds = 1 second)
PROMPT
PROMPT IMPORTANT PARAMETERS RELATING TO LOG FILE SYNC WAITS:
column name format a40 wra
column value format a40 wra
select inst_id, name, value from gv$parameter
where ((value is not null and name like '%log_archive%') or
name like '%commit%' or name like '%event=%' or name like '%lgwr%')
and name not in (select name from gv$parameter where (name like '%log_archive_dest_state%'
and value = 'enable') or name = 'log_archive_format')
order by 1,2,3;
PROMPT
PROMPT V$LOG OUTPUT
PROMPT
PROMPT APPROACH: Review redolog size and members
select inst_id, group#, thread#, sequence#, bytes, status, first_change#
from gv$log
order by first_change#;
PROMPT
PROMPT ASH THRESHOLD...
PROMPT
PROMPT This will be the threshold in milliseconds for average log file sync
PROMPT times. This will be used for the next queries to look for the worst
PROMPT 'log file sync' minutes. Any minutes that have an average log file
PROMPT sync time greater than the threshold will be analyzed further.
column threshold_in_ms new_value threshold format 999999999.999
select min(threshold_in_ms) threshold_in_ms
from (select inst_id, to_char(sample_time,'Mondd_hh24mi') minute,
avg(time_waited)/1000 threshold_in_ms
from gv$active_session_history
where event = 'log file sync'
group by inst_id,to_char(sample_time,'Mondd_hh24mi')
order by 3 desc)
where rownum <= 10;
PROMPT
PROMPT ASH WORST MINUTES FOR LOG FILE SYNC WAITS:
PROMPT
PROMPT APPROACH: These are the minutes where the avg log file sync time
PROMPT was the highest (in milliseconds).
PROMPT
PROMPT Note that TOTAL_WAIT_TIME and AVG_TIME_WAITED do not accurately
PROMPT show total time or average time spent waiting in the database
PROMPT as ASH does not sample all waits. This is simply to look for
PROMPT potential problem timeframes.
column minute format a12 tru
column event format a30 tru
column program format a40 tru
column total_wait_time format 999999999999.999
column avg_time_waited format 999999999999.999
select to_char(sample_time,'Mondd_hh24mi') minute, inst_id, event,
sum(time_waited)/1000 TOTAL_WAIT_TIME , count(*) WAITS,
avg(time_waited)/1000 AVG_TIME_WAITED
from gv$active_session_history
where event = 'log file sync'
group by to_char(sample_time,'Mondd_hh24mi'), inst_id, event
having avg(time_waited)/1000 > &&threshold
order by 1,2;
PROMPT
PROMPT ASH LFS BACKGROUND PROCESS WAITS DURING WORST MINUTES:
PROMPT
PROMPT APPROACH: What is LGWR doing when 'log file sync' waits
PROMPT are happening? LMS info may be relevent for broadcast
PROMPT on commit and LNS data may be relevant for dataguard.
PROMPT
PROMPT Note that TOTAL_WAIT_TIME and AVG_TIME_WAITED do not accurately
PROMPT show total time or average time spent waiting in the database
PROMPT as ASH does not sample all waits. This is simply to look for
PROMPT potential problem timeframes.
PROMPT
PROMPT If more details are needed see the ASH DETAILS FOR WORST
PROMPT MINUTES section at the bottom of the report.
column inst format 999
column minute format a12 tru
column event format a30 tru
column program format a40 wra
select to_char(sample_time,'Mondd_hh24mi') minute, inst_id inst, program, event,
sum(time_waited)/1000 TOTAL_WAIT_TIME , count(*) WAITS,
avg(time_waited)/1000 AVG_TIME_WAITED
from gv$active_session_history
where to_char(sample_time,'Mondd_hh24mi') in (select to_char(sample_time,'Mondd_hh24mi')
from gv$active_session_history
where event = 'log file sync'
group by to_char(sample_time,'Mondd_hh24mi'), inst_id
having avg(time_waited)/1000 > &&threshold)
and (program like '%LG%' or program like '%LMS%' or
program like '%LNS%' or event = 'log file sync')
group by to_char(sample_time,'Mondd_hh24mi'), inst_id, program, event
having sum(time_waited)/1000 > 0
order by 1,2,3,5 desc, 4;
PROMPT
PROMPT HISTOGRAM DATA FOR LFS AND OTHER RELATED WAITS:
PROMPT
PROMPT APPROACH: Look at the wait distribution for log file sync waits
PROMPT by looking at "wait_time_milli". Look at the high wait times then
PROMPT see if you can correlate those with other related wait events.
column event format a40 wra
select inst_id, event, wait_time_milli, wait_count
from gv$event_histogram
where event in ('log file sync','gcs log flush sync',
'log file parallel write','wait for scn ack',
'log file switch completion','gc cr grant 2-way',
'gc buffer busy','gc current block 2-way') or
event like '%LGWR%' or event like '%LNS%'
order by 2 desc,1,3;
PROMPT
PROMPT ORDERED BY WAIT_TIME_MILLI
select inst_id, event, wait_time_milli, wait_count
from gv$event_histogram
where event in ('log file sync','gcs log flush sync',
'log file parallel write','wait for scn ack',
'log file switch completion','gc cr grant 2-way',
'gc buffer busy','gc current block 2-way')
or event like '%LGWR%' or event like '%LNS%'
order by 3,1,2 desc;
PROMPT
PROMPT REDO WRITE STATS
PROMPT
PROMPT "redo write time" in centiseconds (100 per second)
PROMPT 11.1: "redo write broadcast ack time" in centiseconds (100 per second)
PROMPT 11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond)
column value format 99999999999999999999
column milliseconds format 99999999999999.999
select v.version, ss.inst_id, ss.name, ss.value,
decode(substr(version,1,4),
'11.1',decode (name,'redo write time',value*10,
'redo write broadcast ack time',value*10),
'11.2',decode (name,'redo write time',value*10,
'redo write broadcast ack time',value/1000),
decode (name,'redo write time',value*10)) milliseconds
from gv$sysstat ss, v$instance v
where name like 'redo write%' and value > 0
order by 1,2,3;
PROMPT
PROMPT AWR WORST AVG LOG FILE SYNC SNAPS:
PROMPT
PROMPT APPROACH: These are the AWR snaps where the average 'log file sync'
PROMPT times were the highest.
column begin format a12 tru
column end format a12 tru
column name format a13 tru
select dhs.snap_id, dhs.instance_number inst, to_char(dhs.begin_interval_time,'Mondd_hh24mi') BEGIN,
to_char(dhs.end_interval_time,'Mondd_hh24mi') END,
en.name, se.time_waited_micro/1000 total_wait_time, se.total_waits,
se.time_waited_micro/1000 / se.total_waits avg_time_waited
from dba_hist_snapshot dhs, wrh$_system_event se, v$event_name en
where (dhs.snap_id = se.snap_id and dhs.instance_number = se.instance_number)
and se.event_id = en.event_id and en.name = 'log file sync' and
dhs.snap_id in (select snap_id from (
select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited
from wrh$_system_event se, v$event_name en
where se.event_id = en.event_id and en.name = 'log file sync'
order by avg_time_waited desc)
where rownum < 4)
order by 1,2;
PROMPT
PROMPT AWR REDO WRITE STATS
PROMPT
PROMPT "redo write time" in centiseconds (100 per second)
PROMPT 11.1: "redo write broadcast ack time" in centiseconds (100 per second)
PROMPT 11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond)
column stat_name format a30 tru
select v.version, ss.snap_id, ss.instance_number inst, sn.stat_name, ss.value,
decode(substr(version,1,4),
'11.1',decode (stat_name,'redo write time',value*10,
'redo write broadcast ack time',value*10),
'11.2',decode (stat_name,'redo write time',value*10,
'redo write broadcast ack time',value/1000),
decode (stat_name,'redo write time',value*10)) milliseconds
from wrh$_sysstat ss, wrh$_stat_name sn, v$instance v
where ss.stat_id = sn.stat_id
and sn.stat_name like 'redo write%' and ss.value > 0
and ss.snap_id in (select snap_id from (
select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited
from wrh$_system_event se, v$event_name en
where se.event_id = en.event_id and en.name = 'log file sync'
order by avg_time_waited desc)
where rownum < 4)
order by 1,2,3;
PROMPT
PROMPT AWR LFS AND OTHER RELATED WAITS FOR WORST LFS AWRs:
PROMPT
PROMPT APPROACH: These are the AWR snaps where the average 'log file sync'
PROMPT times were the highest. Look at related waits at those times.
column name format a40 tru
select se.snap_id, se.instance_number inst, en.name,
se.total_waits, se.time_waited_micro/1000 total_wait_time,
se.time_waited_micro/1000 / se.total_waits avg_time_waited
from wrh$_system_event se, v$event_name en
where se.event_id = en.event_id and (en.name in
('log file sync','gcs log flush sync',
'log file parallel write','wait for scn ack',
'log file switch completion','gc cr grant 2-way',
'gc buffer busy','gc current block 2-way')
or en.name like '%LG%' 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 '%LG%' 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 '%LG%' or en.name like '%LNS%')
and snap_id in (select snap_id from (
select se.snap_id, se.time_waited_micro/1000 / se.total_waits avg_time_waited
from wrh$_system_event se, v$event_name en
where se.event_id = en.event_id and en.name = 'log file sync'
order by avg_time_waited desc)
where rownum < 4)
order by 1,4,2,3 desc;
PROMPT
PROMPT ASH DETAILS FOR WORST MINUTES:
PROMPT
PROMPT APPROACH: If you cannot determine the problem from the data
PROMPT above, you may need to look at the details of what each session
PROMPT is doing during each 'bad' snap. Most likely you will want to
PROMPT note the times of the high log file sync waits, look at what
PROMPT LGWR is doing at those times, and go from there...
column program format a45 wra
column sample_time format a25 tru
column event format a30 tru
column time_waited format 999999.999
column p1 format a40 tru
column p2 format a40 tru
column p3 format a40 tru
select sample_time, inst_id inst, session_id, program, event, time_waited/1000 TIME_WAITED,
p1text||': '||p1 p1,p2text||': '||p2 p2,p3text||': '||p3 p3
from gv$active_session_history
where to_char(sample_time,'Mondd_hh24mi') in (select
to_char(sample_time,'Mondd_hh24mi')
from gv$active_session_history
where event = 'log file sync'
group by to_char(sample_time,'Mondd_hh24mi'), inst_id
having avg(time_waited)/1000 > &&threshold)
and time_waited > 0.5
order by 1,2,3,4,5;
select to_char(sysdate,'Mondd hh24:mi:ss') TIME from dual;
spool off
PROMPT
PROMPT OUTPUT FILE IS: lfsdiag_&&dbname&×tamp&&suffix
PROMPT
|
결과
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
1646
1647
1648
1649
1650
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
1661
1662
1663
1664
1665
1666
1667
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677
1678
1679
1680
1681
1682
1683
1684
1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
1798
1799
1800
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819
1820
1821
1822
1823
1824
1825
1826
1827
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890
1891
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1924
1925
1926
1927
1928
1929
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
2075
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
2101
2102
2103
2104
2105
2106
2107
2108
2109
2110
2111
2112
2113
2114
2115
2116
2117
2118
2119
2120
2121
2122
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132
2133
2134
2135
2136
2137
2138
2139
2140
2141
2142
2143
2144
2145
2146
2147
2148
2149
2150
2151
2152
2153
2154
2155
2156
2157
2158
2159
2160
2161
2162
2163
2164
2165
2166
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
2181
2182
2183
2184
2185
2186
2187
2188
2189
2190
2191
2192
2193
2194
2195
2196
2197
2198
2199
2200
2201
2202
2203
2204
2205
2206
2207
2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
2218
2219
2220
2221
2222
2223
2224
2225
2226
2227
2228
2229
2230
2231
2232
2233
2234
2235
2236
2237
2238
2239
2240
2241
2242
2243
2244
2245
2246
2247
2248
2249
2250
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
|
$ cat lfsdiag_ORCL19_Mar07_0506.out
LFSDIAG DATA FOR ORCL19_Mar07_0506
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_dest_1 location=/app/oracle/arch
1 log_archive_max_processes 4
1 log_archive_min_succeed_dest 1
1 log_archive_start FALSE
1 log_archive_trace 0
V$LOG OUTPUT
APPROACH: Review redolog size and members
INST_ID GROUP# THREAD# SEQUENCE# BYTES STATUS FIRST_CHANGE#
---------- ---------- ---------- ---------- ---------- ---------------- -------------
1 1 1 736 209715200 INACTIVE 56703760
1 2 1 737 209715200 INACTIVE 56854909
1 3 1 738 209715200 CURRENT 57011487
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
---------------
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).
Note that TOTAL_WAIT_TIME and AVG_TIME_WAITED do not accurately
show total time or average time spent waiting in the database
as ASH does not sample all waits. This is simply to look for
potential problem timeframes.
order by 1,2
*
ERROR at line 8:
ORA-00936: missing expression
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.
Note that TOTAL_WAIT_TIME and AVG_TIME_WAITED do not accurately
show total time or average time spent waiting in the database
as ASH does not sample all waits. This is simply to look for
potential problem timeframes.
If more details are needed see the ASH DETAILS FOR WORST
MINUTES section at the bottom of the report.
having avg(time_waited)/1000 > )
*
ERROR at line 9:
ORA-00936: missing expression
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
---------- ---------------------------------------- --------------- ----------
1 log file sync 1 3119
1 log file sync 2 230
1 log file sync 4 111
1 log file sync 8 12
1 log file parallel write 1 72784
1 log file parallel write 2 36421
1 log file parallel write 4 15658
1 log file parallel write 8 626
1 log file parallel write 16 48
1 log file parallel write 32 2
1 log file parallel write 64 2
1 log file parallel write 128 3
1 LGWR wait for redo copy 1 2903
1 LGWR wait for redo copy 2 286
1 LGWR wait for redo copy 4 166
1 LGWR wait for redo copy 8 42
1 LGWR wait for redo copy 16 2
ORDERED BY WAIT_TIME_MILLI
INST_ID EVENT WAIT_TIME_MILLI WAIT_COUNT
---------- ---------------------------------------- --------------- ----------
1 log file sync 1 3119
1 log file parallel write 1 72784
1 LGWR wait for redo copy 1 2903
1 log file sync 2 230
1 log file parallel write 2 36421
1 LGWR wait for redo copy 2 286
1 log file sync 4 111
1 log file parallel write 4 15658
1 LGWR wait for redo copy 4 166
1 log file sync 8 12
1 log file parallel write 8 626
1 LGWR wait for redo copy 8 42
1 log file parallel write 16 48
1 LGWR wait for redo copy 16 2
1 log file parallel write 32 2
1 log file parallel write 64 2
1 log file parallel write 128 3
REDO WRITE STATS
"redo write time" in centiseconds (100 per second)
11.1: "redo write broadcast ack time" in centiseconds (100 per second)
11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond)
VERSION INST_ID NAME VALUE MILLISECONDS
----------------- ---------- ---------------------------------------- --------------------- -------------------
19.0.0.0.0 1 redo write active strands 125544
19.0.0.0.0 1 redo write finish time 148942153
19.0.0.0.0 1 redo write gather time 5917262
19.0.0.0.0 1 redo write info find 3494
19.0.0.0.0 1 redo write issue time 6782975
19.0.0.0.0 1 redo write schedule time 6694857
19.0.0.0.0 1 redo write size count ( 4KB) 99588
19.0.0.0.0 1 redo write size count ( 8KB) 12260
19.0.0.0.0 1 redo write size count ( 16KB) 6835
19.0.0.0.0 1 redo write size count ( 32KB) 2421
19.0.0.0.0 1 redo write size count ( 128KB) 2677
19.0.0.0.0 1 redo write size count ( 256KB) 509
19.0.0.0.0 1 redo write size count ( 512KB) 362
19.0.0.0.0 1 redo write size count (1024KB) 611
19.0.0.0.0 1 redo write size count (inf) 281
19.0.0.0.0 1 redo write time 14910 149100.000
19.0.0.0.0 1 redo write time (usec) 149104549
19.0.0.0.0 1 redo write total time 150902217
19.0.0.0.0 1 redo writes 125544
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
---------- ---- ------------ ------------ ------------- ----------------- ----------- -----------------
45459 1 Jun10_0800 Jun10_0820 log file sync 707061774.916 5232134828 .135
45459 2 Jun10_0800 Jun10_0820 log file sync 804736685.101 3761330985 .214
45460 1 Jun10_0820 Jun10_0840 log file sync 707279233.205 5232974068 .135
45460 2 Jun10_0820 Jun10_0840 log file sync 804778579.060 3761764711 .214
45461 1 Jun10_0840 Jun10_0900 log file sync 707517270.788 5233829338 .135
45461 2 Jun10_0840 Jun10_0900 log file sync 804824650.093 3762208283 .214
AWR REDO WRITE STATS
"redo write time" in centiseconds (100 per second)
11.1: "redo write broadcast ack time" in centiseconds (100 per second)
11.2: "redo write broadcast ack time" in microseconds (1000 per millisecond)
VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS
----------------- ---------- ---- ------------------------------ --------------------- -------------------
19.0.0.0.0 45459 1 redo write issue time 2014183209340
19.0.0.0.0 45459 1 redo write size count ( 512KB) 76272851
19.0.0.0.0 45459 1 redo write size count ( 512KB) 76272851
19.0.0.0.0 45459 1 redo write size count ( 512KB) 76272851
19.0.0.0.0 45459 1 redo write gather time 1898457087982
19.0.0.0.0 45459 1 redo write gather time 1898457087982
19.0.0.0.0 45459 1 redo write gather time 1898457087982
19.0.0.0.0 45459 1 redo write broadcast lgwr post 4207419
19.0.0.0.0 45459 1 redo write broadcast lgwr post 4207419
19.0.0.0.0 45459 1 redo write broadcast lgwr post 4207419
19.0.0.0.0 45459 1 redo write size count (inf) 110705
19.0.0.0.0 45459 1 redo write size count (inf) 110705
19.0.0.0.0 45459 1 redo write size count (inf) 110705
19.0.0.0.0 45459 1 redo write size count ( 4KB) 2551295165
19.0.0.0.0 45459 1 redo write size count ( 4KB) 2551295165
19.0.0.0.0 45459 1 redo write size count ( 4KB) 2551295165
19.0.0.0.0 45459 1 redo write size count (1024KB) 1594679
19.0.0.0.0 45459 1 redo write size count (1024KB) 1594679
19.0.0.0.0 45459 1 redo write size count (1024KB) 1594679
19.0.0.0.0 45459 1 redo write info find fail 1258788
19.0.0.0.0 45459 1 redo write info find fail 1258788
19.0.0.0.0 45459 1 redo write info find fail 1258788
19.0.0.0.0 45459 1 redo write broadcast ack time 392250803862
19.0.0.0.0 45459 1 redo write broadcast ack time 392250803862
19.0.0.0.0 45459 1 redo write broadcast ack time 392250803862
19.0.0.0.0 45459 1 redo writes coalesced 28701869775
19.0.0.0.0 45459 1 redo writes coalesced 28701869775
19.0.0.0.0 45459 1 redo writes coalesced 28701869775
19.0.0.0.0 45459 1 redo write size count ( 16KB) 8107466291
19.0.0.0.0 45459 1 redo write size count ( 16KB) 8107466291
19.0.0.0.0 45459 1 redo write size count ( 16KB) 8107466291
19.0.0.0.0 45459 1 redo writes 30802172976
19.0.0.0.0 45459 1 redo writes 30802172976
19.0.0.0.0 45459 1 redo writes 30802172976
19.0.0.0.0 45459 1 redo write size count ( 256KB) 695490301
19.0.0.0.0 45459 1 redo write size count ( 256KB) 695490301
19.0.0.0.0 45459 1 redo write size count ( 256KB) 695490301
19.0.0.0.0 45459 1 redo write broadcast ack count 10970335539
19.0.0.0.0 45459 1 redo write broadcast ack count 10970335539
19.0.0.0.0 45459 1 redo write broadcast ack count 10970335539
19.0.0.0.0 45459 1 redo write schedule time 2010397762220
19.0.0.0.0 45459 1 redo write schedule time 2010397762220
19.0.0.0.0 45459 1 redo write schedule time 2010397762220
19.0.0.0.0 45459 1 redo write finish time 2894992040135
19.0.0.0.0 45459 1 redo write finish time 2894992040135
19.0.0.0.0 45459 1 redo write finish time 2894992040135
19.0.0.0.0 45459 1 redo write size count ( 32KB) 8361240824
19.0.0.0.0 45459 1 redo write size count ( 32KB) 8361240824
19.0.0.0.0 45459 1 redo write size count ( 32KB) 8361240824
19.0.0.0.0 45459 1 redo write time (usec) 2902774528376
19.0.0.0.0 45459 1 redo write time (usec) 2902774528376
19.0.0.0.0 45459 1 redo write time (usec) 2902774528376
19.0.0.0.0 45459 1 redo write size count ( 128KB) 6509857319
19.0.0.0.0 45459 1 redo write size count ( 128KB) 6509857319
19.0.0.0.0 45459 1 redo write size count ( 128KB) 6509857319
19.0.0.0.0 45459 1 redo write active strands 80587273636
19.0.0.0.0 45459 1 redo write active strands 80587273636
19.0.0.0.0 45459 1 redo write active strands 80587273636
19.0.0.0.0 45459 1 redo write time 290277453 2902774530.000
19.0.0.0.0 45459 1 redo write time 290277453 2902774530.000
19.0.0.0.0 45459 1 redo write time 290277453 2902774530.000
19.0.0.0.0 45459 1 redo write total time 3399913030882
19.0.0.0.0 45459 1 redo write total time 3399913030882
19.0.0.0.0 45459 1 redo write total time 3399913030882
19.0.0.0.0 45459 1 redo write info find 5242860521
19.0.0.0.0 45459 1 redo write info find 5242860521
19.0.0.0.0 45459 1 redo write info find 5242860521
19.0.0.0.0 45459 1 redo write size count ( 8KB) 4498844847
19.0.0.0.0 45459 1 redo write size count ( 8KB) 4498844847
19.0.0.0.0 45459 1 redo write size count ( 8KB) 4498844847
19.0.0.0.0 45459 1 redo write issue time 2014183209340
19.0.0.0.0 45459 1 redo write issue time 2014183209340
19.0.0.0.0 45459 2 redo write issue time 367427651132
19.0.0.0.0 45459 2 redo write size count ( 512KB) 3921179
19.0.0.0.0 45459 2 redo write size count ( 512KB) 3921179
19.0.0.0.0 45459 2 redo write size count ( 512KB) 3921179
19.0.0.0.0 45459 2 redo write gather time 345634342773
19.0.0.0.0 45459 2 redo write gather time 345634342773
19.0.0.0.0 45459 2 redo write gather time 345634342773
19.0.0.0.0 45459 2 redo write broadcast lgwr post 2920342
19.0.0.0.0 45459 2 redo write broadcast lgwr post 2920342
19.0.0.0.0 45459 2 redo write broadcast lgwr post 2920342
19.0.0.0.0 45459 2 redo write size count (inf) 366973
19.0.0.0.0 45459 2 redo write size count (inf) 366973
19.0.0.0.0 45459 2 redo write size count (inf) 366973
19.0.0.0.0 45459 2 redo write size count ( 4KB) 1400729478
19.0.0.0.0 45459 2 redo write size count ( 4KB) 1400729478
19.0.0.0.0 45459 2 redo write size count ( 4KB) 1400729478
19.0.0.0.0 45459 2 redo write size count (1024KB) 837546
19.0.0.0.0 45459 2 redo write size count (1024KB) 837546
19.0.0.0.0 45459 2 redo write size count (1024KB) 837546
19.0.0.0.0 45459 2 redo write info find fail 1950916
19.0.0.0.0 45459 2 redo write info find fail 1950916
19.0.0.0.0 45459 2 redo write info find fail 1950916
19.0.0.0.0 45459 2 redo write broadcast ack time 121417057080
19.0.0.0.0 45459 2 redo write broadcast ack time 121417057080
19.0.0.0.0 45459 2 redo write broadcast ack time 121417057080
VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS
----------------- ---------- ---- ------------------------------ --------------------- -------------------
19.0.0.0.0 45459 2 redo writes coalesced 5553037194
19.0.0.0.0 45459 2 redo writes coalesced 5553037194
19.0.0.0.0 45459 2 redo writes coalesced 5553037194
19.0.0.0.0 45459 2 redo write size count ( 16KB) 1585016887
19.0.0.0.0 45459 2 redo write size count ( 16KB) 1585016887
19.0.0.0.0 45459 2 redo write size count ( 16KB) 1585016887
19.0.0.0.0 45459 2 redo writes 6943255857
19.0.0.0.0 45459 2 redo writes 6943255857
19.0.0.0.0 45459 2 redo writes 6943255857
19.0.0.0.0 45459 2 redo write size count ( 256KB) 55015824
19.0.0.0.0 45459 2 redo write size count ( 256KB) 55015824
19.0.0.0.0 45459 2 redo write size count ( 256KB) 55015824
19.0.0.0.0 45459 2 redo write broadcast ack count 3361489307
19.0.0.0.0 45459 2 redo write broadcast ack count 3361489307
19.0.0.0.0 45459 2 redo write broadcast ack count 3361489307
19.0.0.0.0 45459 2 redo write schedule time 366329428955
19.0.0.0.0 45459 2 redo write schedule time 366329428955
19.0.0.0.0 45459 2 redo write schedule time 366329428955
19.0.0.0.0 45459 2 redo write finish time 544028690458
19.0.0.0.0 45459 2 redo write finish time 544028690458
19.0.0.0.0 45459 2 redo write finish time 544028690458
19.0.0.0.0 45459 2 redo write size count ( 32KB) 1628574462
19.0.0.0.0 45459 2 redo write size count ( 32KB) 1628574462
19.0.0.0.0 45459 2 redo write size count ( 32KB) 1628574462
19.0.0.0.0 45459 2 redo write time (usec) 545695859274
19.0.0.0.0 45459 2 redo write time (usec) 545695859274
19.0.0.0.0 45459 2 redo write time (usec) 545695859274
19.0.0.0.0 45459 2 redo write size count ( 128KB) 1239200650
19.0.0.0.0 45459 2 redo write size count ( 128KB) 1239200650
19.0.0.0.0 45459 2 redo write size count ( 128KB) 1239200650
19.0.0.0.0 45459 2 redo write active strands 15562170536
19.0.0.0.0 45459 2 redo write active strands 15562170536
19.0.0.0.0 45459 2 redo write active strands 15562170536
19.0.0.0.0 45459 2 redo write time 54569586 545695860.000
19.0.0.0.0 45459 2 redo write time 54569586 545695860.000
19.0.0.0.0 45459 2 redo write time 54569586 545695860.000
19.0.0.0.0 45459 2 redo write total time 653246992734
19.0.0.0.0 45459 2 redo write total time 653246992734
19.0.0.0.0 45459 2 redo write total time 653246992734
19.0.0.0.0 45459 2 redo write info find 3807552092
19.0.0.0.0 45459 2 redo write info find 3807552092
19.0.0.0.0 45459 2 redo write info find 3807552092
19.0.0.0.0 45459 2 redo write size count ( 8KB) 1029592858
19.0.0.0.0 45459 2 redo write size count ( 8KB) 1029592858
19.0.0.0.0 45459 2 redo write size count ( 8KB) 1029592858
19.0.0.0.0 45459 2 redo write issue time 367427651132
19.0.0.0.0 45459 2 redo write issue time 367427651132
19.0.0.0.0 45460 1 redo write broadcast lgwr post 4207985
19.0.0.0.0 45460 1 redo write broadcast lgwr post 4207985
19.0.0.0.0 45460 1 redo write size count (inf) 110730
19.0.0.0.0 45460 1 redo write size count (inf) 110730
19.0.0.0.0 45460 1 redo write size count (inf) 110730
19.0.0.0.0 45460 1 redo write size count ( 4KB) 2551376932
19.0.0.0.0 45460 1 redo write size count ( 4KB) 2551376932
19.0.0.0.0 45460 1 redo write size count ( 4KB) 2551376932
19.0.0.0.0 45460 1 redo write size count (1024KB) 1594834
19.0.0.0.0 45460 1 redo write size count (1024KB) 1594834
19.0.0.0.0 45460 1 redo write size count (1024KB) 1594834
19.0.0.0.0 45460 1 redo write info find fail 1259036
19.0.0.0.0 45460 1 redo write info find fail 1259036
19.0.0.0.0 45460 1 redo write info find fail 1259036
19.0.0.0.0 45460 1 redo write broadcast ack time 392307753897
19.0.0.0.0 45460 1 redo write broadcast ack time 392307753897
19.0.0.0.0 45460 1 redo write broadcast ack time 392307753897
19.0.0.0.0 45460 1 redo writes coalesced 28705591645
19.0.0.0.0 45460 1 redo writes coalesced 28705591645
19.0.0.0.0 45460 1 redo writes coalesced 28705591645
19.0.0.0.0 45460 1 redo write size count ( 16KB) 8108331483
19.0.0.0.0 45460 1 redo write size count ( 16KB) 8108331483
19.0.0.0.0 45460 1 redo write size count ( 16KB) 8108331483
19.0.0.0.0 45460 1 redo writes 30805919346
19.0.0.0.0 45460 1 redo writes 30805919346
19.0.0.0.0 45460 1 redo writes 30805919346
19.0.0.0.0 45460 1 redo write size count ( 256KB) 695512804
19.0.0.0.0 45460 1 redo write size count ( 256KB) 695512804
19.0.0.0.0 45460 1 redo write size count ( 256KB) 695512804
19.0.0.0.0 45460 1 redo write broadcast ack count 10971640815
19.0.0.0.0 45460 1 redo write broadcast ack count 10971640815
19.0.0.0.0 45460 1 redo write broadcast ack count 10971640815
19.0.0.0.0 45460 1 redo write schedule time 2010810503453
19.0.0.0.0 45460 1 redo write schedule time 2010810503453
19.0.0.0.0 45460 1 redo write schedule time 2010810503453
19.0.0.0.0 45460 1 redo write finish time 2895521965987
19.0.0.0.0 45460 1 redo write finish time 2895521965987
19.0.0.0.0 45460 1 redo write finish time 2895521965987
19.0.0.0.0 45460 1 redo write size count ( 32KB) 8362628841
19.0.0.0.0 45460 1 redo write size count ( 32KB) 8362628841
19.0.0.0.0 45460 1 redo write size count ( 32KB) 8362628841
19.0.0.0.0 45460 1 redo write time (usec) 2903305474711
19.0.0.0.0 45460 1 redo write time (usec) 2903305474711
19.0.0.0.0 45460 1 redo write time (usec) 2903305474711
19.0.0.0.0 45460 1 redo write size count ( 128KB) 6510947890
19.0.0.0.0 45460 1 redo write size count ( 128KB) 6510947890
19.0.0.0.0 45460 1 redo write size count ( 128KB) 6510947890
19.0.0.0.0 45460 1 redo write active strands 80603355157
19.0.0.0.0 45460 1 redo write active strands 80603355157
19.0.0.0.0 45460 1 redo write active strands 80603355157
VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS
----------------- ---------- ---- ------------------------------ --------------------- -------------------
19.0.0.0.0 45460 1 redo write time 290330547 2903305470.000
19.0.0.0.0 45460 1 redo write time 290330547 2903305470.000
19.0.0.0.0 45460 1 redo write time 290330547 2903305470.000
19.0.0.0.0 45460 1 redo write total time 3400520964690
19.0.0.0.0 45460 1 redo write total time 3400520964690
19.0.0.0.0 45460 1 redo write total time 3400520964690
19.0.0.0.0 45460 1 redo write info find 5243703323
19.0.0.0.0 45460 1 redo write info find 5243703323
19.0.0.0.0 45460 1 redo write info find 5243703323
19.0.0.0.0 45460 1 redo write size count ( 8KB) 4499141927
19.0.0.0.0 45460 1 redo write size count ( 8KB) 4499141927
19.0.0.0.0 45460 1 redo write size count ( 8KB) 4499141927
19.0.0.0.0 45460 1 redo write issue time 2014596461211
19.0.0.0.0 45460 1 redo write issue time 2014596461211
19.0.0.0.0 45460 1 redo write issue time 2014596461211
19.0.0.0.0 45460 1 redo write size count ( 512KB) 76273912
19.0.0.0.0 45460 1 redo write size count ( 512KB) 76273912
19.0.0.0.0 45460 1 redo write size count ( 512KB) 76273912
19.0.0.0.0 45460 1 redo write gather time 1898851560609
19.0.0.0.0 45460 1 redo write gather time 1898851560609
19.0.0.0.0 45460 1 redo write gather time 1898851560609
19.0.0.0.0 45460 1 redo write broadcast lgwr post 4207985
19.0.0.0.0 45460 2 redo write size count (1024KB) 837653
19.0.0.0.0 45460 2 redo write size count (1024KB) 837653
19.0.0.0.0 45460 2 redo write size count (1024KB) 837653
19.0.0.0.0 45460 2 redo write info find fail 1950998
19.0.0.0.0 45460 2 redo write info find fail 1950998
19.0.0.0.0 45460 2 redo write info find fail 1950998
19.0.0.0.0 45460 2 redo write broadcast ack time 121425355164
19.0.0.0.0 45460 2 redo write broadcast ack time 121425355164
19.0.0.0.0 45460 2 redo write broadcast ack time 121425355164
19.0.0.0.0 45460 2 redo writes coalesced 5553204653
19.0.0.0.0 45460 2 redo writes coalesced 5553204653
19.0.0.0.0 45460 2 redo writes coalesced 5553204653
19.0.0.0.0 45460 2 redo write size count ( 16KB) 1585062656
19.0.0.0.0 45460 2 redo write size count ( 16KB) 1585062656
19.0.0.0.0 45460 2 redo write size count ( 16KB) 1585062656
19.0.0.0.0 45460 2 redo writes 6943799026
19.0.0.0.0 45460 2 redo writes 6943799026
19.0.0.0.0 45460 2 redo writes 6943799026
19.0.0.0.0 45460 2 redo write size count ( 256KB) 55028634
19.0.0.0.0 45460 2 redo write size count ( 256KB) 55028634
19.0.0.0.0 45460 2 redo write size count ( 256KB) 55028634
19.0.0.0.0 45460 2 redo write broadcast ack count 3361707586
19.0.0.0.0 45460 2 redo write broadcast ack count 3361707586
19.0.0.0.0 45460 2 redo write broadcast ack count 3361707586
19.0.0.0.0 45460 2 redo write schedule time 366352992763
19.0.0.0.0 45460 2 redo write schedule time 366352992763
19.0.0.0.0 45460 2 redo write schedule time 366352992763
19.0.0.0.0 45460 2 redo write finish time 544070817285
19.0.0.0.0 45460 2 redo write finish time 544070817285
19.0.0.0.0 45460 2 redo write finish time 544070817285
19.0.0.0.0 45460 2 redo write size count ( 32KB) 1628639011
19.0.0.0.0 45460 2 redo write size count ( 32KB) 1628639011
19.0.0.0.0 45460 2 redo write size count ( 32KB) 1628639011
19.0.0.0.0 45460 2 redo write time (usec) 545738167666
19.0.0.0.0 45460 2 redo write time (usec) 545738167666
19.0.0.0.0 45460 2 redo write time (usec) 545738167666
19.0.0.0.0 45460 2 redo write size count ( 128KB) 1239366319
19.0.0.0.0 45460 2 redo write size count ( 128KB) 1239366319
19.0.0.0.0 45460 2 redo write size count ( 128KB) 1239366319
19.0.0.0.0 45460 2 redo write active strands 15562891577
19.0.0.0.0 45460 2 redo write active strands 15562891577
19.0.0.0.0 45460 2 redo write active strands 15562891577
19.0.0.0.0 45460 2 redo write time 54573817 545738170.000
19.0.0.0.0 45460 2 redo write time 54573817 545738170.000
19.0.0.0.0 45460 2 redo write time 54573817 545738170.000
19.0.0.0.0 45460 2 redo write total time 653298717308
19.0.0.0.0 45460 2 redo write total time 653298717308
19.0.0.0.0 45460 2 redo write total time 653298717308
19.0.0.0.0 45460 2 redo write info find 3807987123
19.0.0.0.0 45460 2 redo write info find 3807987123
19.0.0.0.0 45460 2 redo write info find 3807987123
19.0.0.0.0 45460 2 redo write size count ( 8KB) 1029637449
19.0.0.0.0 45460 2 redo write size count ( 8KB) 1029637449
19.0.0.0.0 45460 2 redo write size count ( 8KB) 1029637449
19.0.0.0.0 45460 2 redo write issue time 367451305937
19.0.0.0.0 45460 2 redo write issue time 367451305937
19.0.0.0.0 45460 2 redo write issue time 367451305937
19.0.0.0.0 45460 2 redo write size count ( 512KB) 3922607
19.0.0.0.0 45460 2 redo write size count ( 512KB) 3922607
19.0.0.0.0 45460 2 redo write size count ( 512KB) 3922607
19.0.0.0.0 45460 2 redo write gather time 345655879587
19.0.0.0.0 45460 2 redo write gather time 345655879587
19.0.0.0.0 45460 2 redo write gather time 345655879587
19.0.0.0.0 45460 2 redo write broadcast lgwr post 2920480
19.0.0.0.0 45460 2 redo write broadcast lgwr post 2920480
19.0.0.0.0 45460 2 redo write broadcast lgwr post 2920480
19.0.0.0.0 45460 2 redo write size count (inf) 366979
19.0.0.0.0 45460 2 redo write size count (inf) 366979
19.0.0.0.0 45460 2 redo write size count (inf) 366979
19.0.0.0.0 45460 2 redo write size count ( 4KB) 1400937718
19.0.0.0.0 45460 2 redo write size count ( 4KB) 1400937718
19.0.0.0.0 45460 2 redo write size count ( 4KB) 1400937718
19.0.0.0.0 45461 1 redo write issue time 2015020281165
19.0.0.0.0 45461 1 redo write size count ( 512KB) 76274931
19.0.0.0.0 45461 1 redo write size count ( 512KB) 76274931
VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS
----------------- ---------- ---- ------------------------------ --------------------- -------------------
19.0.0.0.0 45461 1 redo write size count ( 512KB) 76274931
19.0.0.0.0 45461 1 redo write gather time 1899256713013
19.0.0.0.0 45461 1 redo write gather time 1899256713013
19.0.0.0.0 45461 1 redo write gather time 1899256713013
19.0.0.0.0 45461 1 redo write broadcast lgwr post 4208463
19.0.0.0.0 45461 1 redo write broadcast lgwr post 4208463
19.0.0.0.0 45461 1 redo write broadcast lgwr post 4208463
19.0.0.0.0 45461 1 redo write size count (inf) 110755
19.0.0.0.0 45461 1 redo write size count (inf) 110755
19.0.0.0.0 45461 1 redo write size count (inf) 110755
19.0.0.0.0 45461 1 redo write size count ( 4KB) 2551461119
19.0.0.0.0 45461 1 redo write size count ( 4KB) 2551461119
19.0.0.0.0 45461 1 redo write size count ( 4KB) 2551461119
19.0.0.0.0 45461 1 redo write size count (1024KB) 1595016
19.0.0.0.0 45461 1 redo write size count (1024KB) 1595016
19.0.0.0.0 45461 1 redo write size count (1024KB) 1595016
19.0.0.0.0 45461 1 redo write info find fail 1259233
19.0.0.0.0 45461 1 redo write info find fail 1259233
19.0.0.0.0 45461 1 redo write info find fail 1259233
19.0.0.0.0 45461 1 redo write broadcast ack time 392362080386
19.0.0.0.0 45461 1 redo write broadcast ack time 392362080386
19.0.0.0.0 45461 1 redo write broadcast ack time 392362080386
19.0.0.0.0 45461 1 redo writes coalesced 28709248147
19.0.0.0.0 45461 1 redo writes coalesced 28709248147
19.0.0.0.0 45461 1 redo writes coalesced 28709248147
19.0.0.0.0 45461 1 redo write size count ( 16KB) 8109177604
19.0.0.0.0 45461 1 redo write size count ( 16KB) 8109177604
19.0.0.0.0 45461 1 redo write size count ( 16KB) 8109177604
19.0.0.0.0 45461 1 redo writes 30809602146
19.0.0.0.0 45461 1 redo writes 30809602146
19.0.0.0.0 45461 1 redo writes 30809602146
19.0.0.0.0 45461 1 redo write size count ( 256KB) 695534582
19.0.0.0.0 45461 1 redo write size count ( 256KB) 695534582
19.0.0.0.0 45461 1 redo write size count ( 256KB) 695534582
19.0.0.0.0 45461 1 redo write broadcast ack count 10972903861
19.0.0.0.0 45461 1 redo write broadcast ack count 10972903861
19.0.0.0.0 45461 1 redo write broadcast ack count 10972903861
19.0.0.0.0 45461 1 redo write schedule time 2011233743635
19.0.0.0.0 45461 1 redo write schedule time 2011233743635
19.0.0.0.0 45461 1 redo write schedule time 2011233743635
19.0.0.0.0 45461 1 redo write finish time 2896060950610
19.0.0.0.0 45461 1 redo write finish time 2896060950610
19.0.0.0.0 45461 1 redo write finish time 2896060950610
19.0.0.0.0 45461 1 redo write size count ( 32KB) 8363977341
19.0.0.0.0 45461 1 redo write size count ( 32KB) 8363977341
19.0.0.0.0 45461 1 redo write size count ( 32KB) 8363977341
19.0.0.0.0 45461 1 redo write time (usec) 2903845476696
19.0.0.0.0 45461 1 redo write time (usec) 2903845476696
19.0.0.0.0 45461 1 redo write time (usec) 2903845476696
19.0.0.0.0 45461 1 redo write size count ( 128KB) 6512031933
19.0.0.0.0 45461 1 redo write size count ( 128KB) 6512031933
19.0.0.0.0 45461 1 redo write size count ( 128KB) 6512031933
19.0.0.0.0 45461 1 redo write active strands 80619082101
19.0.0.0.0 45461 1 redo write active strands 80619082101
19.0.0.0.0 45461 1 redo write active strands 80619082101
19.0.0.0.0 45461 1 redo write time 290384548 2903845480.000
19.0.0.0.0 45461 1 redo write time 290384548 2903845480.000
19.0.0.0.0 45461 1 redo write time 290384548 2903845480.000
19.0.0.0.0 45461 1 redo write total time 3401136924724
19.0.0.0.0 45461 1 redo write total time 3401136924724
19.0.0.0.0 45461 1 redo write total time 3401136924724
19.0.0.0.0 45461 1 redo write info find 5244561709
19.0.0.0.0 45461 1 redo write info find 5244561709
19.0.0.0.0 45461 1 redo write info find 5244561709
19.0.0.0.0 45461 1 redo write size count ( 8KB) 4499438877
19.0.0.0.0 45461 1 redo write size count ( 8KB) 4499438877
19.0.0.0.0 45461 1 redo write size count ( 8KB) 4499438877
19.0.0.0.0 45461 1 redo write issue time 2015020281165
19.0.0.0.0 45461 1 redo write issue time 2015020281165
19.0.0.0.0 45461 2 redo write issue time 367475663224
19.0.0.0.0 45461 2 redo write size count ( 512KB) 3924305
19.0.0.0.0 45461 2 redo write size count ( 512KB) 3924305
19.0.0.0.0 45461 2 redo write size count ( 512KB) 3924305
19.0.0.0.0 45461 2 redo write gather time 345678053562
19.0.0.0.0 45461 2 redo write gather time 345678053562
19.0.0.0.0 45461 2 redo write gather time 345678053562
19.0.0.0.0 45461 2 redo write broadcast lgwr post 2920626
19.0.0.0.0 45461 2 redo write broadcast lgwr post 2920626
19.0.0.0.0 45461 2 redo write broadcast lgwr post 2920626
19.0.0.0.0 45461 2 redo write size count (inf) 366988
19.0.0.0.0 45461 2 redo write size count (inf) 366988
19.0.0.0.0 45461 2 redo write size count (inf) 366988
19.0.0.0.0 45461 2 redo write size count ( 4KB) 1401141715
19.0.0.0.0 45461 2 redo write size count ( 4KB) 1401141715
19.0.0.0.0 45461 2 redo write size count ( 4KB) 1401141715
19.0.0.0.0 45461 2 redo write size count (1024KB) 837821
19.0.0.0.0 45461 2 redo write size count (1024KB) 837821
19.0.0.0.0 45461 2 redo write size count (1024KB) 837821
19.0.0.0.0 45461 2 redo write info find fail 1951114
19.0.0.0.0 45461 2 redo write info find fail 1951114
19.0.0.0.0 45461 2 redo write info find fail 1951114
19.0.0.0.0 45461 2 redo write broadcast ack time 121433397090
19.0.0.0.0 45461 2 redo write broadcast ack time 121433397090
19.0.0.0.0 45461 2 redo write broadcast ack time 121433397090
19.0.0.0.0 45461 2 redo writes coalesced 5553380567
19.0.0.0.0 45461 2 redo writes coalesced 5553380567
19.0.0.0.0 45461 2 redo writes coalesced 5553380567
VERSION SNAP_ID INST STAT_NAME VALUE MILLISECONDS
----------------- ---------- ---- ------------------------------ --------------------- -------------------
19.0.0.0.0 45461 2 redo write size count ( 16KB) 1585107992
19.0.0.0.0 45461 2 redo write size count ( 16KB) 1585107992
19.0.0.0.0 45461 2 redo write size count ( 16KB) 1585107992
19.0.0.0.0 45461 2 redo writes 6944342464
19.0.0.0.0 45461 2 redo writes 6944342464
19.0.0.0.0 45461 2 redo writes 6944342464
19.0.0.0.0 45461 2 redo write size count ( 256KB) 55042176
19.0.0.0.0 45461 2 redo write size count ( 256KB) 55042176
19.0.0.0.0 45461 2 redo write size count ( 256KB) 55042176
19.0.0.0.0 45461 2 redo write broadcast ack count 3361919951
19.0.0.0.0 45461 2 redo write broadcast ack count 3361919951
19.0.0.0.0 45461 2 redo write broadcast ack count 3361919951
19.0.0.0.0 45461 2 redo write schedule time 366377256058
19.0.0.0.0 45461 2 redo write schedule time 366377256058
19.0.0.0.0 45461 2 redo write schedule time 366377256058
19.0.0.0.0 45461 2 redo write finish time 544114071730
19.0.0.0.0 45461 2 redo write finish time 544114071730
19.0.0.0.0 45461 2 redo write finish time 544114071730
19.0.0.0.0 45461 2 redo write size count ( 32KB) 1628705074
19.0.0.0.0 45461 2 redo write size count ( 32KB) 1628705074
19.0.0.0.0 45461 2 redo write size count ( 32KB) 1628705074
19.0.0.0.0 45461 2 redo write time (usec) 545781607200
19.0.0.0.0 45461 2 redo write time (usec) 545781607200
19.0.0.0.0 45461 2 redo write time (usec) 545781607200
19.0.0.0.0 45461 2 redo write size count ( 128KB) 1239534052
19.0.0.0.0 45461 2 redo write size count ( 128KB) 1239534052
19.0.0.0.0 45461 2 redo write size count ( 128KB) 1239534052
19.0.0.0.0 45461 2 redo write active strands 15563624648
19.0.0.0.0 45461 2 redo write active strands 15563624648
19.0.0.0.0 45461 2 redo write active strands 15563624648
19.0.0.0.0 45461 2 redo write time 54578161 545781610.000
19.0.0.0.0 45461 2 redo write time 54578161 545781610.000
19.0.0.0.0 45461 2 redo write time 54578161 545781610.000
19.0.0.0.0 45461 2 redo write total time 653351837589
19.0.0.0.0 45461 2 redo write total time 653351837589
19.0.0.0.0 45461 2 redo write total time 653351837589
19.0.0.0.0 45461 2 redo write info find 3808432070
19.0.0.0.0 45461 2 redo write info find 3808432070
19.0.0.0.0 45461 2 redo write info find 3808432070
19.0.0.0.0 45461 2 redo write size count ( 8KB) 1029682342
19.0.0.0.0 45461 2 redo write size count ( 8KB) 1029682342
19.0.0.0.0 45461 2 redo write size count ( 8KB) 1029682342
19.0.0.0.0 45461 2 redo write issue time 367475663224
19.0.0.0.0 45461 2 redo write issue time 367475663224
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
---------- ---- ---------------------------------------- ----------- ----------------- -----------------
45459 1 wait for scn ack 7 2792.847 398.978
45459 1 log file switch completion 864978 18962707.962 21.923
45459 2 log file switch completion 333809 6627350.665 19.854
45459 2 log file sync 3761330985 804736685.101 .214
45459 1 log file sync 5232134828 707061774.916 .135
45459 2 gcs log flush sync 592866 66921.416 .113
45459 1 gcs log flush sync 2115610 136651.425 .065
45459 2 gc cr grant 2-way 157895720 8812251.098 .056
45459 2 wait for scn ack 53 2.916 .055
45459 1 gc cr grant 2-way 1270534740 69210207.531 .054
45459 2 gc current block 2-way 88311471 4787976.791 .054
45459 1 gc current block 2-way 206137682 10606871.793 .051
45459 1 LGWR wait for redo copy 2.5565E+10 1073967463.029 .042
45459 2 LGWR wait for redo copy 4730101862 191907331.362 .041
45459 1 log file parallel write 3.0801E+10 813416230.036 .026
45459 2 log file parallel write 6942570662 162068080.706 .023
45460 1 wait for scn ack 7 2792.847 398.978
45460 1 log file switch completion 865291 18969894.784 21.923
45460 2 log file switch completion 333811 6627421.523 19.854
45460 2 log file sync 3761764711 804778579.060 .214
45460 1 log file sync 5232974068 707279233.205 .135
45460 2 gcs log flush sync 592913 66924.295 .113
45460 1 gcs log flush sync 2115768 136673.233 .065
45460 2 gc cr grant 2-way 157908808 8812979.596 .056
45460 2 wait for scn ack 53 2.916 .055
45460 1 gc cr grant 2-way 1270730794 69224290.155 .054
45460 2 gc current block 2-way 88312152 4788019.288 .054
45460 1 gc current block 2-way 206201238 10610019.227 .051
45460 1 LGWR wait for redo copy 2.5570E+10 1074223004.384 .042
45460 2 LGWR wait for redo copy 4730404578 191915465.759 .041
45460 1 log file parallel write 3.0805E+10 813522974.270 .026
45460 2 log file parallel write 6943113816 162084973.558 .023
45461 1 wait for scn ack 7 2792.847 398.978
45461 1 log file switch completion 865625 18977556.250 21.924
45461 2 log file switch completion 333818 6627580.562 19.854
45461 2 log file sync 3762208283 804824650.093 .214
45461 1 log file sync 5233829338 707517270.788 .135
45461 2 gcs log flush sync 593073 66932.239 .113
45461 1 gcs log flush sync 2116043 136695.510 .065
45461 2 gc cr grant 2-way 157920040 8813679.523 .056
45461 2 wait for scn ack 53 2.916 .055
45461 1 gc cr grant 2-way 1271040514 69241235.776 .054
45461 2 gc current block 2-way 88312900 4788068.583 .054
45461 1 gc current block 2-way 206205587 10610265.413 .051
45461 1 LGWR wait for redo copy 2.5574E+10 1074491689.986 .042
45461 2 LGWR wait for redo copy 4730710334 191923866.852 .041
45461 1 log file parallel write 3.0809E+10 813628204.687 .026
45461 2 log file parallel write 6943657268 162102247.385 .023
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
---------- ---- ---------------------------------------- --------------- ----------
45459 1 wait for scn ack 128 1
45459 1 wait for scn ack 256 1
45459 1 wait for scn ack 512 3
45459 1 wait for scn ack 1024 2
45459 2 wait for scn ack .00390625 2
45459 2 wait for scn ack .015625 9
45459 2 wait for scn ack .03125 13
45459 2 wait for scn ack .0625 14
45459 2 wait for scn ack .125 10
45459 2 wait for scn ack .25 3
45459 2 wait for scn ack .5 2
45459 1 log file sync .000976563 2
45459 1 log file sync .001953125 734
45459 1 log file sync .00390625 2220
45459 1 log file sync .0078125 3002
45459 1 log file sync .015625 76011
45459 1 log file sync .03125 262755
45459 1 log file sync .0625 2428846674
45459 1 log file sync .125 1432886355
45459 1 log file sync .25 820876330
45459 1 log file sync .5 396778743
45459 1 log file sync 1 128664673
45459 1 log file sync 2 22028539
45459 1 log file sync 4 3222620
45459 1 log file sync 8 2798125
45459 1 log file sync 16 1917681
45459 1 log file sync 32 491325
45459 1 log file sync 64 38621
45459 1 log file sync 128 6884
45459 1 log file sync 256 863
45459 1 log file sync 512 399
45459 1 log file sync 1024 590
45459 1 log file sync 2048 47
45459 1 log file sync 4096 39
45459 2 log file sync .001953125 50
45459 2 log file sync .00390625 950
45459 2 log file sync .0078125 1304
45459 2 log file sync .015625 4912
45459 2 log file sync .03125 48483
45459 2 log file sync .0625 1828382344
45459 2 log file sync .125 1091449156
45459 2 log file sync .25 403380462
45459 2 log file sync .5 286226523
45459 2 log file sync 1 101937063
45459 2 log file sync 2 24560336
45459 2 log file sync 4 21623084
45459 2 log file sync 8 18223869
45459 2 log file sync 16 9677381
45459 2 log file sync 32 2250855
45459 2 log file sync 64 144368
45459 2 log file sync 128 113877
45459 2 log file sync 256 661
45459 2 log file sync 512 32
45459 2 log file sync 1024 14
45459 2 log file sync 2048 1
45459 1 log file switch completion .001953125 1
45459 1 log file switch completion .00390625 5
45459 1 log file switch completion .0078125 17
45459 1 log file switch completion .015625 8
45459 1 log file switch completion .03125 1
45459 1 log file switch completion .0625 24
45459 1 log file switch completion .125 288
45459 1 log file switch completion .25 1466
45459 1 log file switch completion .5 3900
45459 1 log file switch completion 1 7869
45459 1 log file switch completion 2 15860
45459 1 log file switch completion 4 32111
45459 1 log file switch completion 8 65581
45459 1 log file switch completion 16 137267
45459 1 log file switch completion 32 448335
45459 1 log file switch completion 64 154204
45459 1 log file switch completion 128 130
45459 1 log file switch completion 256 20
45459 2 log file switch completion .001953125 1
45459 2 log file switch completion .00390625 1
45459 2 log file switch completion .0078125 7
45459 2 log file switch completion .015625 1
45459 2 log file switch completion .0625 9
45459 2 log file switch completion .125 147
45459 2 log file switch completion .25 596
45459 2 log file switch completion .5 1681
45459 2 log file switch completion 1 3862
45459 2 log file switch completion 2 7727
45459 2 log file switch completion 4 16184
45459 2 log file switch completion 8 32815
45459 2 log file switch completion 16 68893
45459 2 log file switch completion 32 156976
45459 2 log file switch completion 64 48959
45459 2 log file switch completion 128 39
45459 1 log file parallel write .00390625 35845
45459 1 log file parallel write .0078125 1112646
45459 1 log file parallel write .015625 6787903792
45459 1 log file parallel write .03125 1.7613E+10
45459 1 log file parallel write .0625 4962822279
45459 1 log file parallel write .125 1285672908
45459 1 log file parallel write .25 145724897
45459 1 log file parallel write .5 4250782
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45459 1 log file parallel write 1 251729
45459 1 log file parallel write 2 42233
45459 1 log file parallel write 4 7438
45459 1 log file parallel write 8 478
45459 1 log file parallel write 16 140
45459 1 log file parallel write 32 32
45459 1 log file parallel write 64 2
45459 1 log file parallel write 128 2
45459 1 log file parallel write 256 4
45459 1 log file parallel write 512 1
45459 1 log file parallel write 1024 3
45459 1 log file parallel write 2048 1
45459 1 log file parallel write 4096 2
45459 2 log file parallel write .00390625 4532
45459 2 log file parallel write .0078125 247147
45459 2 log file parallel write .015625 2298068138
45459 2 log file parallel write .03125 3447790471
45459 2 log file parallel write .0625 1050052037
45459 2 log file parallel write .125 135935174
45459 2 log file parallel write .25 8185206
45459 2 log file parallel write .5 1658830
45459 2 log file parallel write 1 490449
45459 2 log file parallel write 2 127473
45459 2 log file parallel write 4 11099
45459 2 log file parallel write 8 251
45459 2 log file parallel write 16 17
45459 2 log file parallel write 32 26
45459 2 log file parallel write 4096 2
45459 1 gcs log flush sync .000976563 16877
45459 1 gcs log flush sync .001953125 129845
45459 1 gcs log flush sync .00390625 183753
45459 1 gcs log flush sync .0078125 238709
45459 1 gcs log flush sync .015625 200648
45459 1 gcs log flush sync .03125 143916
45459 1 gcs log flush sync .0625 407745
45459 1 gcs log flush sync .125 524324
45459 1 gcs log flush sync .25 209642
45459 1 gcs log flush sync .5 47583
45459 1 gcs log flush sync 1 10621
45459 1 gcs log flush sync 2 1284
45459 1 gcs log flush sync 4 496
45459 1 gcs log flush sync 8 139
45459 1 gcs log flush sync 16 24
45459 1 gcs log flush sync 32 2
45459 2 gcs log flush sync .000976563 5154
45459 2 gcs log flush sync .001953125 43275
45459 2 gcs log flush sync .00390625 80217
45459 2 gcs log flush sync .0078125 75607
45459 2 gcs log flush sync .015625 52411
45459 2 gcs log flush sync .03125 40998
45459 2 gcs log flush sync .0625 109830
45459 2 gcs log flush sync .125 90273
45459 2 gcs log flush sync .25 41725
45459 2 gcs log flush sync .5 24701
45459 2 gcs log flush sync 1 16405
45459 2 gcs log flush sync 2 8865
45459 2 gcs log flush sync 4 2804
45459 2 gcs log flush sync 8 545
45459 2 gcs log flush sync 16 68
45459 1 gc current block 2-way .00390625 1
45459 1 gc current block 2-way .0078125 28802
45459 1 gc current block 2-way .015625 88119
45459 1 gc current block 2-way .03125 8816941
45459 1 gc current block 2-way .0625 166551601
45459 1 gc current block 2-way .125 28515062
45459 1 gc current block 2-way .25 1549844
45459 1 gc current block 2-way .5 368580
45459 1 gc current block 2-way 1 115084
45459 1 gc current block 2-way 2 39942
45459 1 gc current block 2-way 4 42593
45459 1 gc current block 2-way 8 17801
45459 1 gc current block 2-way 16 2775
45459 1 gc current block 2-way 32 124
45459 1 gc current block 2-way 64 80
45459 1 gc current block 2-way 128 119
45459 1 gc current block 2-way 256 101
45459 1 gc current block 2-way 512 17
45459 1 gc current block 2-way 1024 1
45459 2 gc current block 2-way .00390625 1
45459 2 gc current block 2-way .0078125 13917
45459 2 gc current block 2-way .015625 32005
45459 2 gc current block 2-way .03125 460866
45459 2 gc current block 2-way .0625 75874105
45459 2 gc current block 2-way .125 10937798
45459 2 gc current block 2-way .25 629323
45459 2 gc current block 2-way .5 198598
45459 2 gc current block 2-way 1 125458
45459 2 gc current block 2-way 2 20029
45459 2 gc current block 2-way 4 12359
45459 2 gc current block 2-way 8 5218
45459 2 gc current block 2-way 16 1432
45459 2 gc current block 2-way 32 130
45459 2 gc current block 2-way 64 4
45459 2 gc current block 2-way 128 1
45459 2 gc current block 2-way 1024 1
45459 1 gc cr grant 2-way .00390625 539
45459 1 gc cr grant 2-way .0078125 210792
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45459 1 gc cr grant 2-way .015625 1304326
45459 1 gc cr grant 2-way .03125 160405959
45459 1 gc cr grant 2-way .0625 924397470
45459 1 gc cr grant 2-way .125 165989521
45459 1 gc cr grant 2-way .25 13972146
45459 1 gc cr grant 2-way .5 2297114
45459 1 gc cr grant 2-way 1 853708
45459 1 gc cr grant 2-way 2 424057
45459 1 gc cr grant 2-way 4 453473
45459 1 gc cr grant 2-way 8 155790
45459 1 gc cr grant 2-way 16 25123
45459 1 gc cr grant 2-way 32 3540
45459 1 gc cr grant 2-way 64 5741
45459 1 gc cr grant 2-way 128 9119
45459 1 gc cr grant 2-way 256 7053
45459 1 gc cr grant 2-way 512 4534
45459 1 gc cr grant 2-way 1024 16
45459 1 gc cr grant 2-way 2048 2
45459 1 gc cr grant 2-way 8192 5
45459 2 gc cr grant 2-way .00390625 18
45459 2 gc cr grant 2-way .0078125 27155
45459 2 gc cr grant 2-way .015625 131568
45459 2 gc cr grant 2-way .03125 5591405
45459 2 gc cr grant 2-way .0625 124059282
45459 2 gc cr grant 2-way .125 24190050
45459 2 gc cr grant 2-way .25 3013253
45459 2 gc cr grant 2-way .5 532673
45459 2 gc cr grant 2-way 1 255706
45459 2 gc cr grant 2-way 2 45905
45459 2 gc cr grant 2-way 4 28047
45459 2 gc cr grant 2-way 8 12093
45459 2 gc cr grant 2-way 16 3106
45459 2 gc cr grant 2-way 32 182
45459 2 gc cr grant 2-way 64 13
45459 2 gc cr grant 2-way 128 9
45459 1 LGWR wait for redo copy .000976563 338900182
45459 1 LGWR wait for redo copy .001953125 234283017
45459 1 LGWR wait for redo copy .00390625 165523574
45459 1 LGWR wait for redo copy .0078125 1506976542
45459 1 LGWR wait for redo copy .015625 8997602736
45459 1 LGWR wait for redo copy .03125 7467239882
45459 1 LGWR wait for redo copy .0625 3212892280
45459 1 LGWR wait for redo copy .125 1796611275
45459 1 LGWR wait for redo copy .25 1116742145
45459 1 LGWR wait for redo copy .5 587689814
45459 1 LGWR wait for redo copy 1 136924424
45459 1 LGWR wait for redo copy 2 2668821
45459 1 LGWR wait for redo copy 4 696900
45459 1 LGWR wait for redo copy 8 420949
45459 1 LGWR wait for redo copy 16 229480
45459 1 LGWR wait for redo copy 32 36498
45459 1 LGWR wait for redo copy 64 1047
45459 1 LGWR wait for redo copy 128 16
45459 1 LGWR wait for redo copy 256 3
45459 2 LGWR wait for redo copy .000976563 65071411
45459 2 LGWR wait for redo copy .001953125 48714508
45459 2 LGWR wait for redo copy .00390625 52872686
45459 2 LGWR wait for redo copy .0078125 395970878
45459 2 LGWR wait for redo copy .015625 1594058612
45459 2 LGWR wait for redo copy .03125 1289313617
45459 2 LGWR wait for redo copy .0625 580326368
45459 2 LGWR wait for redo copy .125 331531842
45459 2 LGWR wait for redo copy .25 293173114
45459 2 LGWR wait for redo copy .5 73428854
45459 2 LGWR wait for redo copy 1 2786818
45459 2 LGWR wait for redo copy 2 1295654
45459 2 LGWR wait for redo copy 4 943110
45459 2 LGWR wait for redo copy 8 490393
45459 2 LGWR wait for redo copy 16 111086
45459 2 LGWR wait for redo copy 32 12471
45459 2 LGWR wait for redo copy 64 527
45459 2 LGWR wait for redo copy 128 34
45459 2 LGWR wait for redo copy 256 3
45460 1 wait for scn ack 128 1
45460 1 wait for scn ack 256 1
45460 1 wait for scn ack 512 3
45460 1 wait for scn ack 1024 2
45460 2 wait for scn ack .00390625 2
45460 2 wait for scn ack .015625 9
45460 2 wait for scn ack .03125 13
45460 2 wait for scn ack .0625 14
45460 2 wait for scn ack .125 10
45460 2 wait for scn ack .25 3
45460 2 wait for scn ack .5 2
45460 1 log file sync .000976563 2
45460 1 log file sync .001953125 734
45460 1 log file sync .00390625 2220
45460 1 log file sync .0078125 3002
45460 1 log file sync .015625 76011
45460 1 log file sync .03125 262755
45460 1 log file sync .0625 2429163887
45460 1 log file sync .125 1433075665
45460 1 log file sync .25 820982591
45460 1 log file sync .5 396873315
45460 1 log file sync 1 128766543
45460 1 log file sync 2 22057218
45460 1 log file sync 4 3225280
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45460 1 log file sync 8 2799030
45460 1 log file sync 16 1917838
45460 1 log file sync 32 491325
45460 1 log file sync 64 38621
45460 1 log file sync 128 6884
45460 1 log file sync 256 863
45460 1 log file sync 512 399
45460 1 log file sync 1024 590
45460 1 log file sync 2048 47
45460 1 log file sync 4096 39
45460 2 log file sync .001953125 50
45460 2 log file sync .00390625 950
45460 2 log file sync .0078125 1304
45460 2 log file sync .015625 4912
45460 2 log file sync .03125 48483
45460 2 log file sync .0625 1828589956
45460 2 log file sync .125 1091607127
45460 2 log file sync .25 403431953
45460 2 log file sync .5 286241138
45460 2 log file sync 1 101937991
45460 2 log file sync 2 24561156
45460 2 log file sync 4 21623905
45460 2 log file sync 8 18224000
45460 2 log file sync 16 9677381
45460 2 log file sync 32 2250855
45460 2 log file sync 64 144368
45460 2 log file sync 128 113877
45460 2 log file sync 256 661
45460 2 log file sync 512 32
45460 2 log file sync 1024 14
45460 2 log file sync 2048 1
45460 1 log file switch completion .001953125 1
45460 1 log file switch completion .00390625 5
45460 1 log file switch completion .0078125 17
45460 1 log file switch completion .015625 8
45460 1 log file switch completion .03125 1
45460 1 log file switch completion .0625 24
45460 1 log file switch completion .125 288
45460 1 log file switch completion .25 1466
45460 1 log file switch completion .5 3901
45460 1 log file switch completion 1 7873
45460 1 log file switch completion 2 15864
45460 1 log file switch completion 4 32119
45460 1 log file switch completion 8 65603
45460 1 log file switch completion 16 137299
45460 1 log file switch completion 32 448516
45460 1 log file switch completion 64 154263
45460 1 log file switch completion 128 130
45460 1 log file switch completion 256 20
45460 2 log file switch completion .001953125 1
45460 2 log file switch completion .00390625 1
45460 2 log file switch completion .0078125 7
45460 2 log file switch completion .015625 1
45460 2 log file switch completion .0625 9
45460 2 log file switch completion .125 147
45460 2 log file switch completion .25 596
45460 2 log file switch completion .5 1681
45460 2 log file switch completion 1 3862
45460 2 log file switch completion 2 7727
45460 2 log file switch completion 4 16184
45460 2 log file switch completion 8 32815
45460 2 log file switch completion 16 68893
45460 2 log file switch completion 32 156976
45460 2 log file switch completion 64 48961
45460 2 log file switch completion 128 39
45460 1 log file parallel write .00390625 35845
45460 1 log file parallel write .0078125 1112646
45460 1 log file parallel write .015625 6788002177
45460 1 log file parallel write .03125 1.7616E+10
45460 1 log file parallel write .0625 4963803209
45460 1 log file parallel write .125 1285747349
45460 1 log file parallel write .25 145727866
45460 1 log file parallel write .5 4251240
45460 1 log file parallel write 1 251819
45460 1 log file parallel write 2 42247
45460 1 log file parallel write 4 7438
45460 1 log file parallel write 8 478
45460 1 log file parallel write 16 140
45460 1 log file parallel write 32 32
45460 1 log file parallel write 64 2
45460 1 log file parallel write 128 2
45460 1 log file parallel write 256 4
45460 1 log file parallel write 512 1
45460 1 log file parallel write 1024 3
45460 1 log file parallel write 2048 1
45460 1 log file parallel write 4096 2
45460 2 log file parallel write .00390625 4532
45460 2 log file parallel write .0078125 247147
45460 2 log file parallel write .015625 2298249893
45460 2 log file parallel write .03125 3447960486
45460 2 log file parallel write .0625 1050190382
45460 2 log file parallel write .125 135984944
45460 2 log file parallel write .25 8188306
45460 2 log file parallel write .5 1659020
45460 2 log file parallel write 1 490472
45460 2 log file parallel write 2 127477
45460 2 log file parallel write 4 11100
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45460 2 log file parallel write 8 251
45460 2 log file parallel write 16 17
45460 2 log file parallel write 32 26
45460 2 log file parallel write 4096 2
45460 1 gcs log flush sync .000976563 16877
45460 1 gcs log flush sync .001953125 129859
45460 1 gcs log flush sync .00390625 183783
45460 1 gcs log flush sync .0078125 238738
45460 1 gcs log flush sync .015625 200653
45460 1 gcs log flush sync .03125 143919
45460 1 gcs log flush sync .0625 407759
45460 1 gcs log flush sync .125 524352
45460 1 gcs log flush sync .25 209657
45460 1 gcs log flush sync .5 47592
45460 1 gcs log flush sync 1 10632
45460 1 gcs log flush sync 2 1284
45460 1 gcs log flush sync 4 496
45460 1 gcs log flush sync 8 140
45460 1 gcs log flush sync 16 24
45460 1 gcs log flush sync 32 2
45460 2 gcs log flush sync .000976563 5154
45460 2 gcs log flush sync .001953125 43276
45460 2 gcs log flush sync .00390625 80222
45460 2 gcs log flush sync .0078125 75611
45460 2 gcs log flush sync .015625 52417
45460 2 gcs log flush sync .03125 40998
45460 2 gcs log flush sync .0625 109849
45460 2 gcs log flush sync .125 90286
45460 2 gcs log flush sync .25 41734
45460 2 gcs log flush sync .5 24701
45460 2 gcs log flush sync 1 16405
45460 2 gcs log flush sync 2 8865
45460 2 gcs log flush sync 4 2804
45460 2 gcs log flush sync 8 545
45460 2 gcs log flush sync 16 68
45460 1 gc current block 2-way .00390625 1
45460 1 gc current block 2-way .0078125 28809
45460 1 gc current block 2-way .015625 88178
45460 1 gc current block 2-way .03125 8819415
45460 1 gc current block 2-way .0625 166602579
45460 1 gc current block 2-way .125 28524543
45460 1 gc current block 2-way .25 1550244
45460 1 gc current block 2-way .5 368683
45460 1 gc current block 2-way 1 115123
45460 1 gc current block 2-way 2 39947
45460 1 gc current block 2-way 4 42595
45460 1 gc current block 2-way 8 17802
45460 1 gc current block 2-way 16 2775
45460 1 gc current block 2-way 32 124
45460 1 gc current block 2-way 64 80
45460 1 gc current block 2-way 128 119
45460 1 gc current block 2-way 256 101
45460 1 gc current block 2-way 512 17
45460 1 gc current block 2-way 1024 1
45460 2 gc current block 2-way .00390625 1
45460 2 gc current block 2-way .0078125 13919
45460 2 gc current block 2-way .015625 32006
45460 2 gc current block 2-way .03125 460871
45460 2 gc current block 2-way .0625 75874559
45460 2 gc current block 2-way .125 10937988
45460 2 gc current block 2-way .25 629347
45460 2 gc current block 2-way .5 198600
45460 2 gc current block 2-way 1 125459
45460 2 gc current block 2-way 2 20029
45460 2 gc current block 2-way 4 12359
45460 2 gc current block 2-way 8 5218
45460 2 gc current block 2-way 16 1432
45460 2 gc current block 2-way 32 130
45460 2 gc current block 2-way 64 4
45460 2 gc current block 2-way 128 1
45460 2 gc current block 2-way 1024 1
45460 1 gc cr grant 2-way .00390625 539
45460 1 gc cr grant 2-way .0078125 210882
45460 1 gc cr grant 2-way .015625 1305146
45460 1 gc cr grant 2-way .03125 160438173
45460 1 gc cr grant 2-way .0625 924537087
45460 1 gc cr grant 2-way .125 166010063
45460 1 gc cr grant 2-way .25 13974212
45460 1 gc cr grant 2-way .5 2297469
45460 1 gc cr grant 2-way 1 853960
45460 1 gc cr grant 2-way 2 424105
45460 1 gc cr grant 2-way 4 453498
45460 1 gc cr grant 2-way 8 155792
45460 1 gc cr grant 2-way 16 25125
45460 1 gc cr grant 2-way 32 3543
45460 1 gc cr grant 2-way 64 5744
45460 1 gc cr grant 2-way 128 9121
45460 1 gc cr grant 2-way 256 7061
45460 1 gc cr grant 2-way 512 4542
45460 1 gc cr grant 2-way 1024 16
45460 1 gc cr grant 2-way 2048 2
45460 1 gc cr grant 2-way 8192 5
45460 2 gc cr grant 2-way .00390625 18
45460 2 gc cr grant 2-way .0078125 27158
45460 2 gc cr grant 2-way .015625 131570
45460 2 gc cr grant 2-way .03125 5591637
45460 2 gc cr grant 2-way .0625 124069602
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45460 2 gc cr grant 2-way .125 24192265
45460 2 gc cr grant 2-way .25 3013529
45460 2 gc cr grant 2-way .5 532695
45460 2 gc cr grant 2-way 1 255715
45460 2 gc cr grant 2-way 2 45907
45460 2 gc cr grant 2-way 4 28048
45460 2 gc cr grant 2-way 8 12094
45460 2 gc cr grant 2-way 16 3106
45460 2 gc cr grant 2-way 32 182
45460 2 gc cr grant 2-way 64 13
45460 2 gc cr grant 2-way 128 9
45460 1 LGWR wait for redo copy .000976563 338953247
45460 1 LGWR wait for redo copy .001953125 234327358
45460 1 LGWR wait for redo copy .00390625 165549975
45460 1 LGWR wait for redo copy .0078125 1507111251
45460 1 LGWR wait for redo copy .015625 8998904351
45460 1 LGWR wait for redo copy .03125 7468714768
45460 1 LGWR wait for redo copy .0625 3213569839
45460 1 LGWR wait for redo copy .125 1796935761
45460 1 LGWR wait for redo copy .25 1116993709
45460 1 LGWR wait for redo copy .5 587848914
45460 1 LGWR wait for redo copy 1 136992673
45460 1 LGWR wait for redo copy 2 2670451
45460 1 LGWR wait for redo copy 4 697208
45460 1 LGWR wait for redo copy 8 421001
45460 1 LGWR wait for redo copy 16 229485
45460 1 LGWR wait for redo copy 32 36498
45460 1 LGWR wait for redo copy 64 1047
45460 1 LGWR wait for redo copy 128 16
45460 1 LGWR wait for redo copy 256 3
45460 2 LGWR wait for redo copy .000976563 65076876
45460 2 LGWR wait for redo copy .001953125 48718531
45460 2 LGWR wait for redo copy .00390625 52875714
45460 2 LGWR wait for redo copy .0078125 396009334
45460 2 LGWR wait for redo copy .015625 1594187199
45460 2 LGWR wait for redo copy .03125 1289371910
45460 2 LGWR wait for redo copy .0625 580364649
45460 2 LGWR wait for redo copy .125 331548719
45460 2 LGWR wait for redo copy .25 293181866
45460 2 LGWR wait for redo copy .5 73429758
45460 2 LGWR wait for redo copy 1 2786836
45460 2 LGWR wait for redo copy 2 1295698
45460 2 LGWR wait for redo copy 4 943141
45460 2 LGWR wait for redo copy 8 490399
45460 2 LGWR wait for redo copy 16 111086
45460 2 LGWR wait for redo copy 32 12471
45460 2 LGWR wait for redo copy 64 527
45460 2 LGWR wait for redo copy 128 34
45460 2 LGWR wait for redo copy 256 3
45461 1 wait for scn ack 128 1
45461 1 wait for scn ack 256 1
45461 1 wait for scn ack 512 3
45461 1 wait for scn ack 1024 2
45461 2 wait for scn ack .00390625 2
45461 2 wait for scn ack .015625 9
45461 2 wait for scn ack .03125 13
45461 2 wait for scn ack .0625 14
45461 2 wait for scn ack .125 10
45461 2 wait for scn ack .25 3
45461 2 wait for scn ack .5 2
45461 1 log file sync .000976563 2
45461 1 log file sync .001953125 734
45461 1 log file sync .00390625 2220
45461 1 log file sync .0078125 3002
45461 1 log file sync .015625 76011
45461 1 log file sync .03125 262755
45461 1 log file sync .0625 2429474206
45461 1 log file sync .125 1433262891
45461 1 log file sync .25 821089208
45461 1 log file sync .5 396974833
45461 1 log file sync 1 128882255
45461 1 log file sync 2 22089275
45461 1 log file sync 4 3228065
45461 1 log file sync 8 2800045
45461 1 log file sync 16 1918062
45461 1 log file sync 32 491356
45461 1 log file sync 64 38621
45461 1 log file sync 128 6886
45461 1 log file sync 256 863
45461 1 log file sync 512 399
45461 1 log file sync 1024 590
45461 1 log file sync 2048 47
45461 1 log file sync 4096 39
45461 2 log file sync .001953125 50
45461 2 log file sync .00390625 950
45461 2 log file sync .0078125 1304
45461 2 log file sync .015625 4912
45461 2 log file sync .03125 48483
45461 2 log file sync .0625 1828795616
45461 2 log file sync .125 1091773042
45461 2 log file sync .25 403485519
45461 2 log file sync .5 286256059
45461 2 log file sync 1 101939203
45461 2 log file sync 2 24562329
45461 2 log file sync 4 21625299
45461 2 log file sync 8 18224259
45461 2 log file sync 16 9677381
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45461 2 log file sync 32 2250855
45461 2 log file sync 64 144368
45461 2 log file sync 128 113877
45461 2 log file sync 256 661
45461 2 log file sync 512 32
45461 2 log file sync 1024 14
45461 2 log file sync 2048 1
45461 1 log file switch completion .001953125 1
45461 1 log file switch completion .00390625 5
45461 1 log file switch completion .0078125 17
45461 1 log file switch completion .015625 8
45461 1 log file switch completion .03125 1
45461 1 log file switch completion .0625 24
45461 1 log file switch completion .125 288
45461 1 log file switch completion .25 1466
45461 1 log file switch completion .5 3904
45461 1 log file switch completion 1 7875
45461 1 log file switch completion 2 15866
45461 1 log file switch completion 4 32130
45461 1 log file switch completion 8 65616
45461 1 log file switch completion 16 137354
45461 1 log file switch completion 32 448692
45461 1 log file switch completion 64 154336
45461 1 log file switch completion 128 130
45461 1 log file switch completion 256 20
45461 2 log file switch completion .001953125 1
45461 2 log file switch completion .00390625 1
45461 2 log file switch completion .0078125 7
45461 2 log file switch completion .015625 1
45461 2 log file switch completion .0625 9
45461 2 log file switch completion .125 147
45461 2 log file switch completion .25 596
45461 2 log file switch completion .5 1682
45461 2 log file switch completion 1 3862
45461 2 log file switch completion 2 7727
45461 2 log file switch completion 4 16184
45461 2 log file switch completion 8 32815
45461 2 log file switch completion 16 68894
45461 2 log file switch completion 32 156981
45461 2 log file switch completion 64 48961
45461 2 log file switch completion 128 39
45461 1 log file parallel write .00390625 35845
45461 1 log file parallel write .0078125 1112648
45461 1 log file parallel write .015625 6788096555
45461 1 log file parallel write .03125 1.7618E+10
45461 1 log file parallel write .0625 4964778156
45461 1 log file parallel write .125 1285822900
45461 1 log file parallel write .25 145730567
45461 1 log file parallel write .5 4251637
45461 1 log file parallel write 1 251881
45461 1 log file parallel write 2 42258
45461 1 log file parallel write 4 7438
45461 1 log file parallel write 8 478
45461 1 log file parallel write 16 140
45461 1 log file parallel write 32 32
45461 1 log file parallel write 64 2
45461 1 log file parallel write 128 2
45461 1 log file parallel write 256 4
45461 1 log file parallel write 512 1
45461 1 log file parallel write 1024 3
45461 1 log file parallel write 2048 1
45461 1 log file parallel write 4096 2
45461 2 log file parallel write .00390625 4532
45461 2 log file parallel write .0078125 247147
45461 2 log file parallel write .015625 2298420268
45461 2 log file parallel write .03125 3448136221
45461 2 log file parallel write .0625 1050332526
45461 2 log file parallel write .125 136036461
45461 2 log file parallel write .25 8191679
45461 2 log file parallel write .5 1659267
45461 2 log file parallel write 1 490489
45461 2 log file parallel write 2 127479
45461 2 log file parallel write 4 11100
45461 2 log file parallel write 8 251
45461 2 log file parallel write 16 17
45461 2 log file parallel write 32 26
45461 2 log file parallel write 4096 2
45461 1 gcs log flush sync .000976563 16877
45461 1 gcs log flush sync .001953125 129887
45461 1 gcs log flush sync .00390625 183838
45461 1 gcs log flush sync .0078125 238783
45461 1 gcs log flush sync .015625 200661
45461 1 gcs log flush sync .03125 143929
45461 1 gcs log flush sync .0625 407785
45461 1 gcs log flush sync .125 524407
45461 1 gcs log flush sync .25 209682
45461 1 gcs log flush sync .5 47604
45461 1 gcs log flush sync 1 10642
45461 1 gcs log flush sync 2 1284
45461 1 gcs log flush sync 4 496
45461 1 gcs log flush sync 8 140
45461 1 gcs log flush sync 16 24
45461 1 gcs log flush sync 32 2
45461 2 gcs log flush sync .000976563 5154
45461 2 gcs log flush sync .001953125 43296
45461 2 gcs log flush sync .00390625 80230
45461 2 gcs log flush sync .0078125 75635
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45461 2 gcs log flush sync .015625 52435
45461 2 gcs log flush sync .03125 41006
45461 2 gcs log flush sync .0625 109878
45461 2 gcs log flush sync .125 90312
45461 2 gcs log flush sync .25 41744
45461 2 gcs log flush sync .5 24703
45461 2 gcs log flush sync 1 16405
45461 2 gcs log flush sync 2 8865
45461 2 gcs log flush sync 4 2804
45461 2 gcs log flush sync 8 545
45461 2 gcs log flush sync 16 68
45461 1 gc current block 2-way .00390625 1
45461 1 gc current block 2-way .0078125 28809
45461 1 gc current block 2-way .015625 88185
45461 1 gc current block 2-way .03125 8819491
45461 1 gc current block 2-way .0625 166605911
45461 1 gc current block 2-way .125 28525372
45461 1 gc current block 2-way .25 1550328
45461 1 gc current block 2-way .5 368691
45461 1 gc current block 2-way 1 115132
45461 1 gc current block 2-way 2 39947
45461 1 gc current block 2-way 4 42595
45461 1 gc current block 2-way 8 17803
45461 1 gc current block 2-way 16 2775
45461 1 gc current block 2-way 32 124
45461 1 gc current block 2-way 64 80
45461 1 gc current block 2-way 128 119
45461 1 gc current block 2-way 256 101
45461 1 gc current block 2-way 512 17
45461 1 gc current block 2-way 1024 1
45461 2 gc current block 2-way .00390625 1
45461 2 gc current block 2-way .0078125 13919
45461 2 gc current block 2-way .015625 32006
45461 2 gc current block 2-way .03125 460872
45461 2 gc current block 2-way .0625 75875054
45461 2 gc current block 2-way .125 10938196
45461 2 gc current block 2-way .25 629385
45461 2 gc current block 2-way .5 198606
45461 2 gc current block 2-way 1 125460
45461 2 gc current block 2-way 2 20029
45461 2 gc current block 2-way 4 12359
45461 2 gc current block 2-way 8 5218
45461 2 gc current block 2-way 16 1432
45461 2 gc current block 2-way 32 130
45461 2 gc current block 2-way 64 4
45461 2 gc current block 2-way 128 1
45461 2 gc current block 2-way 1024 1
45461 1 gc cr grant 2-way .00390625 539
45461 1 gc cr grant 2-way .0078125 210937
45461 1 gc cr grant 2-way .015625 1306183
45461 1 gc cr grant 2-way .03125 160490248
45461 1 gc cr grant 2-way .0625 924759501
45461 1 gc cr grant 2-way .125 166040526
45461 1 gc cr grant 2-way .25 13977014
45461 1 gc cr grant 2-way .5 2297959
45461 1 gc cr grant 2-way 1 854239
45461 1 gc cr grant 2-way 2 424154
45461 1 gc cr grant 2-way 4 453539
45461 1 gc cr grant 2-way 8 155804
45461 1 gc cr grant 2-way 16 25126
45461 1 gc cr grant 2-way 32 3545
45461 1 gc cr grant 2-way 64 5753
45461 1 gc cr grant 2-way 128 9122
45461 1 gc cr grant 2-way 256 7065
45461 1 gc cr grant 2-way 512 4545
45461 1 gc cr grant 2-way 1024 16
45461 1 gc cr grant 2-way 2048 2
45461 1 gc cr grant 2-way 8192 5
45461 2 gc cr grant 2-way .00390625 18
45461 2 gc cr grant 2-way .0078125 27160
45461 2 gc cr grant 2-way .015625 131573
45461 2 gc cr grant 2-way .03125 5591790
45461 2 gc cr grant 2-way .0625 124077556
45461 2 gc cr grant 2-way .125 24194730
45461 2 gc cr grant 2-way .25 3014202
45461 2 gc cr grant 2-way .5 532720
45461 2 gc cr grant 2-way 1 255723
45461 2 gc cr grant 2-way 2 45909
45461 2 gc cr grant 2-way 4 28049
45461 2 gc cr grant 2-way 8 12094
45461 2 gc cr grant 2-way 16 3106
45461 2 gc cr grant 2-way 32 182
45461 2 gc cr grant 2-way 64 13
45461 2 gc cr grant 2-way 128 9
45461 1 LGWR wait for redo copy .000976563 339004978
45461 1 LGWR wait for redo copy .001953125 234370917
45461 1 LGWR wait for redo copy .00390625 165575377
45461 1 LGWR wait for redo copy .0078125 1507241796
45461 1 LGWR wait for redo copy .015625 9000187655
45461 1 LGWR wait for redo copy .03125 7470184716
45461 1 LGWR wait for redo copy .0625 3214247923
45461 1 LGWR wait for redo copy .125 1797259418
45461 1 LGWR wait for redo copy .25 1117252109
45461 1 LGWR wait for redo copy .5 588027027
45461 1 LGWR wait for redo copy 1 137067465
45461 1 LGWR wait for redo copy 2 2672311
45461 1 LGWR wait for redo copy 4 697539
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45461 1 LGWR wait for redo copy 8 421079
45461 1 LGWR wait for redo copy 16 229497
45461 1 LGWR wait for redo copy 32 36499
45461 1 LGWR wait for redo copy 64 1047
45461 1 LGWR wait for redo copy 128 16
45461 1 LGWR wait for redo copy 256 3
45461 2 LGWR wait for redo copy .000976563 65082484
45461 2 LGWR wait for redo copy .001953125 48722860
45461 2 LGWR wait for redo copy .00390625 52878869
45461 2 LGWR wait for redo copy .0078125 396050386
45461 2 LGWR wait for redo copy .015625 1594313300
45461 2 LGWR wait for redo copy .03125 1289429208
45461 2 LGWR wait for redo copy .0625 580404232
45461 2 LGWR wait for redo copy .125 331567390
45461 2 LGWR wait for redo copy .25 293190989
45461 2 LGWR wait for redo copy .5 73430371
45461 2 LGWR wait for redo copy 1 2786857
45461 2 LGWR wait for redo copy 2 1295782
45461 2 LGWR wait for redo copy 4 943188
45461 2 LGWR wait for redo copy 8 490408
45461 2 LGWR wait for redo copy 16 111086
45461 2 LGWR wait for redo copy 32 12471
45461 2 LGWR wait for redo copy 64 527
45461 2 LGWR wait for redo copy 128 34
45461 2 LGWR wait for redo copy 256 3
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
---------- ---- ---------------------------------------- --------------- ----------
45459 1 log file sync .000976563 2
45459 1 gcs log flush sync .000976563 16877
45459 1 LGWR wait for redo copy .000976563 338900182
45459 2 gcs log flush sync .000976563 5154
45459 2 LGWR wait for redo copy .000976563 65071411
45459 1 log file sync .001953125 734
45459 1 log file switch completion .001953125 1
45459 1 gcs log flush sync .001953125 129845
45459 1 LGWR wait for redo copy .001953125 234283017
45459 2 log file sync .001953125 50
45459 2 log file switch completion .001953125 1
45459 2 gcs log flush sync .001953125 43275
45459 2 LGWR wait for redo copy .001953125 48714508
45459 1 log file sync .00390625 2220
45459 1 log file switch completion .00390625 5
45459 1 log file parallel write .00390625 35845
45459 1 gcs log flush sync .00390625 183753
45459 1 gc current block 2-way .00390625 1
45459 1 gc cr grant 2-way .00390625 539
45459 1 LGWR wait for redo copy .00390625 165523574
45459 2 wait for scn ack .00390625 2
45459 2 log file sync .00390625 950
45459 2 log file switch completion .00390625 1
45459 2 log file parallel write .00390625 4532
45459 2 gcs log flush sync .00390625 80217
45459 2 gc current block 2-way .00390625 1
45459 2 gc cr grant 2-way .00390625 18
45459 2 LGWR wait for redo copy .00390625 52872686
45459 1 log file sync .0078125 3002
45459 1 log file switch completion .0078125 17
45459 1 log file parallel write .0078125 1112646
45459 1 gcs log flush sync .0078125 238709
45459 1 gc current block 2-way .0078125 28802
45459 1 gc cr grant 2-way .0078125 210792
45459 1 LGWR wait for redo copy .0078125 1506976542
45459 2 log file sync .0078125 1304
45459 2 log file switch completion .0078125 7
45459 2 log file parallel write .0078125 247147
45459 2 gcs log flush sync .0078125 75607
45459 2 gc current block 2-way .0078125 13917
45459 2 gc cr grant 2-way .0078125 27155
45459 2 LGWR wait for redo copy .0078125 395970878
45459 1 log file sync .015625 76011
45459 1 log file switch completion .015625 8
45459 1 log file parallel write .015625 6787903792
45459 1 gcs log flush sync .015625 200648
45459 1 gc current block 2-way .015625 88119
45459 1 gc cr grant 2-way .015625 1304326
45459 1 LGWR wait for redo copy .015625 8997602736
45459 2 wait for scn ack .015625 9
45459 2 log file sync .015625 4912
45459 2 log file switch completion .015625 1
45459 2 log file parallel write .015625 2298068138
45459 2 gcs log flush sync .015625 52411
45459 2 gc current block 2-way .015625 32005
45459 2 gc cr grant 2-way .015625 131568
45459 2 LGWR wait for redo copy .015625 1594058612
45459 1 log file sync .03125 262755
45459 1 log file switch completion .03125 1
45459 1 log file parallel write .03125 1.7613E+10
45459 1 gcs log flush sync .03125 143916
45459 1 gc current block 2-way .03125 8816941
45459 1 gc cr grant 2-way .03125 160405959
45459 1 LGWR wait for redo copy .03125 7467239882
45459 2 wait for scn ack .03125 13
45459 2 log file sync .03125 48483
45459 2 log file parallel write .03125 3447790471
45459 2 gcs log flush sync .03125 40998
45459 2 gc current block 2-way .03125 460866
45459 2 gc cr grant 2-way .03125 5591405
45459 2 LGWR wait for redo copy .03125 1289313617
45459 1 log file sync .0625 2428846674
45459 1 log file switch completion .0625 24
45459 1 log file parallel write .0625 4962822279
45459 1 gcs log flush sync .0625 407745
45459 1 gc current block 2-way .0625 166551601
45459 1 gc cr grant 2-way .0625 924397470
45459 1 LGWR wait for redo copy .0625 3212892280
45459 2 wait for scn ack .0625 14
45459 2 log file sync .0625 1828382344
45459 2 log file switch completion .0625 9
45459 2 log file parallel write .0625 1050052037
45459 2 gcs log flush sync .0625 109830
45459 2 gc current block 2-way .0625 75874105
45459 2 gc cr grant 2-way .0625 124059282
45459 2 LGWR wait for redo copy .0625 580326368
45459 1 log file sync .125 1432886355
45459 1 log file switch completion .125 288
45459 1 log file parallel write .125 1285672908
45459 1 gcs log flush sync .125 524324
45459 1 gc current block 2-way .125 28515062
45459 1 gc cr grant 2-way .125 165989521
45459 1 LGWR wait for redo copy .125 1796611275
45459 2 wait for scn ack .125 10
45459 2 log file sync .125 1091449156
45459 2 log file switch completion .125 147
45459 2 log file parallel write .125 135935174
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45459 2 gcs log flush sync .125 90273
45459 2 gc current block 2-way .125 10937798
45459 2 gc cr grant 2-way .125 24190050
45459 2 LGWR wait for redo copy .125 331531842
45459 1 log file sync .25 820876330
45459 1 log file switch completion .25 1466
45459 1 log file parallel write .25 145724897
45459 1 gcs log flush sync .25 209642
45459 1 gc current block 2-way .25 1549844
45459 1 gc cr grant 2-way .25 13972146
45459 1 LGWR wait for redo copy .25 1116742145
45459 2 wait for scn ack .25 3
45459 2 log file sync .25 403380462
45459 2 log file switch completion .25 596
45459 2 log file parallel write .25 8185206
45459 2 gcs log flush sync .25 41725
45459 2 gc current block 2-way .25 629323
45459 2 gc cr grant 2-way .25 3013253
45459 2 LGWR wait for redo copy .25 293173114
45459 1 log file sync .5 396778743
45459 1 log file switch completion .5 3900
45459 1 log file parallel write .5 4250782
45459 1 gcs log flush sync .5 47583
45459 1 gc current block 2-way .5 368580
45459 1 gc cr grant 2-way .5 2297114
45459 1 LGWR wait for redo copy .5 587689814
45459 2 wait for scn ack .5 2
45459 2 log file sync .5 286226523
45459 2 log file switch completion .5 1681
45459 2 log file parallel write .5 1658830
45459 2 gcs log flush sync .5 24701
45459 2 gc current block 2-way .5 198598
45459 2 gc cr grant 2-way .5 532673
45459 2 LGWR wait for redo copy .5 73428854
45459 1 log file sync 1 128664673
45459 1 log file switch completion 1 7869
45459 1 log file parallel write 1 251729
45459 1 gcs log flush sync 1 10621
45459 1 gc current block 2-way 1 115084
45459 1 gc cr grant 2-way 1 853708
45459 1 LGWR wait for redo copy 1 136924424
45459 2 log file sync 1 101937063
45459 2 log file switch completion 1 3862
45459 2 log file parallel write 1 490449
45459 2 gcs log flush sync 1 16405
45459 2 gc current block 2-way 1 125458
45459 2 gc cr grant 2-way 1 255706
45459 2 LGWR wait for redo copy 1 2786818
45459 1 log file sync 2 22028539
45459 1 log file switch completion 2 15860
45459 1 log file parallel write 2 42233
45459 1 gcs log flush sync 2 1284
45459 1 gc current block 2-way 2 39942
45459 1 gc cr grant 2-way 2 424057
45459 1 LGWR wait for redo copy 2 2668821
45459 2 log file sync 2 24560336
45459 2 log file switch completion 2 7727
45459 2 log file parallel write 2 127473
45459 2 gcs log flush sync 2 8865
45459 2 gc current block 2-way 2 20029
45459 2 gc cr grant 2-way 2 45905
45459 2 LGWR wait for redo copy 2 1295654
45459 1 log file sync 4 3222620
45459 1 log file switch completion 4 32111
45459 1 log file parallel write 4 7438
45459 1 gcs log flush sync 4 496
45459 1 gc current block 2-way 4 42593
45459 1 gc cr grant 2-way 4 453473
45459 1 LGWR wait for redo copy 4 696900
45459 2 log file sync 4 21623084
45459 2 log file switch completion 4 16184
45459 2 log file parallel write 4 11099
45459 2 gcs log flush sync 4 2804
45459 2 gc current block 2-way 4 12359
45459 2 gc cr grant 2-way 4 28047
45459 2 LGWR wait for redo copy 4 943110
45459 1 log file sync 8 2798125
45459 1 log file switch completion 8 65581
45459 1 log file parallel write 8 478
45459 1 gcs log flush sync 8 139
45459 1 gc current block 2-way 8 17801
45459 1 gc cr grant 2-way 8 155790
45459 1 LGWR wait for redo copy 8 420949
45459 2 log file sync 8 18223869
45459 2 log file switch completion 8 32815
45459 2 log file parallel write 8 251
45459 2 gcs log flush sync 8 545
45459 2 gc current block 2-way 8 5218
45459 2 gc cr grant 2-way 8 12093
45459 2 LGWR wait for redo copy 8 490393
45459 1 log file sync 16 1917681
45459 1 log file switch completion 16 137267
45459 1 log file parallel write 16 140
45459 1 gcs log flush sync 16 24
45459 1 gc current block 2-way 16 2775
45459 1 gc cr grant 2-way 16 25123
45459 1 LGWR wait for redo copy 16 229480
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45459 2 log file sync 16 9677381
45459 2 log file switch completion 16 68893
45459 2 log file parallel write 16 17
45459 2 gcs log flush sync 16 68
45459 2 gc current block 2-way 16 1432
45459 2 gc cr grant 2-way 16 3106
45459 2 LGWR wait for redo copy 16 111086
45459 1 log file sync 32 491325
45459 1 log file switch completion 32 448335
45459 1 log file parallel write 32 32
45459 1 gcs log flush sync 32 2
45459 1 gc current block 2-way 32 124
45459 1 gc cr grant 2-way 32 3540
45459 1 LGWR wait for redo copy 32 36498
45459 2 log file sync 32 2250855
45459 2 log file switch completion 32 156976
45459 2 log file parallel write 32 26
45459 2 gc current block 2-way 32 130
45459 2 gc cr grant 2-way 32 182
45459 2 LGWR wait for redo copy 32 12471
45459 1 log file sync 64 38621
45459 1 log file switch completion 64 154204
45459 1 log file parallel write 64 2
45459 1 gc current block 2-way 64 80
45459 1 gc cr grant 2-way 64 5741
45459 1 LGWR wait for redo copy 64 1047
45459 2 log file sync 64 144368
45459 2 log file switch completion 64 48959
45459 2 gc current block 2-way 64 4
45459 2 gc cr grant 2-way 64 13
45459 2 LGWR wait for redo copy 64 527
45459 1 wait for scn ack 128 1
45459 1 log file sync 128 6884
45459 1 log file switch completion 128 130
45459 1 log file parallel write 128 2
45459 1 gc current block 2-way 128 119
45459 1 gc cr grant 2-way 128 9119
45459 1 LGWR wait for redo copy 128 16
45459 2 log file sync 128 113877
45459 2 log file switch completion 128 39
45459 2 gc current block 2-way 128 1
45459 2 gc cr grant 2-way 128 9
45459 2 LGWR wait for redo copy 128 34
45459 1 wait for scn ack 256 1
45459 1 log file sync 256 863
45459 1 log file switch completion 256 20
45459 1 log file parallel write 256 4
45459 1 gc current block 2-way 256 101
45459 1 gc cr grant 2-way 256 7053
45459 1 LGWR wait for redo copy 256 3
45459 2 log file sync 256 661
45459 2 LGWR wait for redo copy 256 3
45459 1 wait for scn ack 512 3
45459 1 log file sync 512 399
45459 1 log file parallel write 512 1
45459 1 gc current block 2-way 512 17
45459 1 gc cr grant 2-way 512 4534
45459 2 log file sync 512 32
45459 1 wait for scn ack 1024 2
45459 1 log file sync 1024 590
45459 1 log file parallel write 1024 3
45459 1 gc current block 2-way 1024 1
45459 1 gc cr grant 2-way 1024 16
45459 2 log file sync 1024 14
45459 2 gc current block 2-way 1024 1
45459 1 log file sync 2048 47
45459 1 log file parallel write 2048 1
45459 1 gc cr grant 2-way 2048 2
45459 2 log file sync 2048 1
45459 1 log file sync 4096 39
45459 1 log file parallel write 4096 2
45459 2 log file parallel write 4096 2
45459 1 gc cr grant 2-way 8192 5
45460 1 log file sync .000976563 2
45460 1 gcs log flush sync .000976563 16877
45460 1 LGWR wait for redo copy .000976563 338953247
45460 2 gcs log flush sync .000976563 5154
45460 2 LGWR wait for redo copy .000976563 65076876
45460 1 log file sync .001953125 734
45460 1 log file switch completion .001953125 1
45460 1 gcs log flush sync .001953125 129859
45460 1 LGWR wait for redo copy .001953125 234327358
45460 2 log file sync .001953125 50
45460 2 log file switch completion .001953125 1
45460 2 gcs log flush sync .001953125 43276
45460 2 LGWR wait for redo copy .001953125 48718531
45460 1 log file sync .00390625 2220
45460 1 log file switch completion .00390625 5
45460 1 log file parallel write .00390625 35845
45460 1 gcs log flush sync .00390625 183783
45460 1 gc current block 2-way .00390625 1
45460 1 gc cr grant 2-way .00390625 539
45460 1 LGWR wait for redo copy .00390625 165549975
45460 2 wait for scn ack .00390625 2
45460 2 log file sync .00390625 950
45460 2 log file switch completion .00390625 1
45460 2 log file parallel write .00390625 4532
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45460 2 gcs log flush sync .00390625 80222
45460 2 gc current block 2-way .00390625 1
45460 2 gc cr grant 2-way .00390625 18
45460 2 LGWR wait for redo copy .00390625 52875714
45460 1 log file sync .0078125 3002
45460 1 log file switch completion .0078125 17
45460 1 log file parallel write .0078125 1112646
45460 1 gcs log flush sync .0078125 238738
45460 1 gc current block 2-way .0078125 28809
45460 1 gc cr grant 2-way .0078125 210882
45460 1 LGWR wait for redo copy .0078125 1507111251
45460 2 log file sync .0078125 1304
45460 2 log file switch completion .0078125 7
45460 2 log file parallel write .0078125 247147
45460 2 gcs log flush sync .0078125 75611
45460 2 gc current block 2-way .0078125 13919
45460 2 gc cr grant 2-way .0078125 27158
45460 2 LGWR wait for redo copy .0078125 396009334
45460 1 log file sync .015625 76011
45460 1 log file switch completion .015625 8
45460 1 log file parallel write .015625 6788002177
45460 1 gcs log flush sync .015625 200653
45460 1 gc current block 2-way .015625 88178
45460 1 gc cr grant 2-way .015625 1305146
45460 1 LGWR wait for redo copy .015625 8998904351
45460 2 wait for scn ack .015625 9
45460 2 log file sync .015625 4912
45460 2 log file switch completion .015625 1
45460 2 log file parallel write .015625 2298249893
45460 2 gcs log flush sync .015625 52417
45460 2 gc current block 2-way .015625 32006
45460 2 gc cr grant 2-way .015625 131570
45460 2 LGWR wait for redo copy .015625 1594187199
45460 1 log file sync .03125 262755
45460 1 log file switch completion .03125 1
45460 1 log file parallel write .03125 1.7616E+10
45460 1 gcs log flush sync .03125 143919
45460 1 gc current block 2-way .03125 8819415
45460 1 gc cr grant 2-way .03125 160438173
45460 1 LGWR wait for redo copy .03125 7468714768
45460 2 wait for scn ack .03125 13
45460 2 log file sync .03125 48483
45460 2 log file parallel write .03125 3447960486
45460 2 gcs log flush sync .03125 40998
45460 2 gc current block 2-way .03125 460871
45460 2 gc cr grant 2-way .03125 5591637
45460 2 LGWR wait for redo copy .03125 1289371910
45460 1 log file sync .0625 2429163887
45460 1 log file switch completion .0625 24
45460 1 log file parallel write .0625 4963803209
45460 1 gcs log flush sync .0625 407759
45460 1 gc current block 2-way .0625 166602579
45460 1 gc cr grant 2-way .0625 924537087
45460 1 LGWR wait for redo copy .0625 3213569839
45460 2 wait for scn ack .0625 14
45460 2 log file sync .0625 1828589956
45460 2 log file switch completion .0625 9
45460 2 log file parallel write .0625 1050190382
45460 2 gcs log flush sync .0625 109849
45460 2 gc current block 2-way .0625 75874559
45460 2 gc cr grant 2-way .0625 124069602
45460 2 LGWR wait for redo copy .0625 580364649
45460 1 log file sync .125 1433075665
45460 1 log file switch completion .125 288
45460 1 log file parallel write .125 1285747349
45460 1 gcs log flush sync .125 524352
45460 1 gc current block 2-way .125 28524543
45460 1 gc cr grant 2-way .125 166010063
45460 1 LGWR wait for redo copy .125 1796935761
45460 2 wait for scn ack .125 10
45460 2 log file sync .125 1091607127
45460 2 log file switch completion .125 147
45460 2 log file parallel write .125 135984944
45460 2 gcs log flush sync .125 90286
45460 2 gc current block 2-way .125 10937988
45460 2 gc cr grant 2-way .125 24192265
45460 2 LGWR wait for redo copy .125 331548719
45460 1 log file sync .25 820982591
45460 1 log file switch completion .25 1466
45460 1 log file parallel write .25 145727866
45460 1 gcs log flush sync .25 209657
45460 1 gc current block 2-way .25 1550244
45460 1 gc cr grant 2-way .25 13974212
45460 1 LGWR wait for redo copy .25 1116993709
45460 2 wait for scn ack .25 3
45460 2 log file sync .25 403431953
45460 2 log file switch completion .25 596
45460 2 log file parallel write .25 8188306
45460 2 gcs log flush sync .25 41734
45460 2 gc current block 2-way .25 629347
45460 2 gc cr grant 2-way .25 3013529
45460 2 LGWR wait for redo copy .25 293181866
45460 1 log file sync .5 396873315
45460 1 log file switch completion .5 3901
45460 1 log file parallel write .5 4251240
45460 1 gcs log flush sync .5 47592
45460 1 gc current block 2-way .5 368683
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45460 1 gc cr grant 2-way .5 2297469
45460 1 LGWR wait for redo copy .5 587848914
45460 2 wait for scn ack .5 2
45460 2 log file sync .5 286241138
45460 2 log file switch completion .5 1681
45460 2 log file parallel write .5 1659020
45460 2 gcs log flush sync .5 24701
45460 2 gc current block 2-way .5 198600
45460 2 gc cr grant 2-way .5 532695
45460 2 LGWR wait for redo copy .5 73429758
45460 1 log file sync 1 128766543
45460 1 log file switch completion 1 7873
45460 1 log file parallel write 1 251819
45460 1 gcs log flush sync 1 10632
45460 1 gc current block 2-way 1 115123
45460 1 gc cr grant 2-way 1 853960
45460 1 LGWR wait for redo copy 1 136992673
45460 2 log file sync 1 101937991
45460 2 log file switch completion 1 3862
45460 2 log file parallel write 1 490472
45460 2 gcs log flush sync 1 16405
45460 2 gc current block 2-way 1 125459
45460 2 gc cr grant 2-way 1 255715
45460 2 LGWR wait for redo copy 1 2786836
45460 1 log file sync 2 22057218
45460 1 log file switch completion 2 15864
45460 1 log file parallel write 2 42247
45460 1 gcs log flush sync 2 1284
45460 1 gc current block 2-way 2 39947
45460 1 gc cr grant 2-way 2 424105
45460 1 LGWR wait for redo copy 2 2670451
45460 2 log file sync 2 24561156
45460 2 log file switch completion 2 7727
45460 2 log file parallel write 2 127477
45460 2 gcs log flush sync 2 8865
45460 2 gc current block 2-way 2 20029
45460 2 gc cr grant 2-way 2 45907
45460 2 LGWR wait for redo copy 2 1295698
45460 1 log file sync 4 3225280
45460 1 log file switch completion 4 32119
45460 1 log file parallel write 4 7438
45460 1 gcs log flush sync 4 496
45460 1 gc current block 2-way 4 42595
45460 1 gc cr grant 2-way 4 453498
45460 1 LGWR wait for redo copy 4 697208
45460 2 log file sync 4 21623905
45460 2 log file switch completion 4 16184
45460 2 log file parallel write 4 11100
45460 2 gcs log flush sync 4 2804
45460 2 gc current block 2-way 4 12359
45460 2 gc cr grant 2-way 4 28048
45460 2 LGWR wait for redo copy 4 943141
45460 1 log file sync 8 2799030
45460 1 log file switch completion 8 65603
45460 1 log file parallel write 8 478
45460 1 gcs log flush sync 8 140
45460 1 gc current block 2-way 8 17802
45460 1 gc cr grant 2-way 8 155792
45460 1 LGWR wait for redo copy 8 421001
45460 2 log file sync 8 18224000
45460 2 log file switch completion 8 32815
45460 2 log file parallel write 8 251
45460 2 gcs log flush sync 8 545
45460 2 gc current block 2-way 8 5218
45460 2 gc cr grant 2-way 8 12094
45460 2 LGWR wait for redo copy 8 490399
45460 1 log file sync 16 1917838
45460 1 log file switch completion 16 137299
45460 1 log file parallel write 16 140
45460 1 gcs log flush sync 16 24
45460 1 gc current block 2-way 16 2775
45460 1 gc cr grant 2-way 16 25125
45460 1 LGWR wait for redo copy 16 229485
45460 2 log file sync 16 9677381
45460 2 log file switch completion 16 68893
45460 2 log file parallel write 16 17
45460 2 gcs log flush sync 16 68
45460 2 gc current block 2-way 16 1432
45460 2 gc cr grant 2-way 16 3106
45460 2 LGWR wait for redo copy 16 111086
45460 1 log file sync 32 491325
45460 1 log file switch completion 32 448516
45460 1 log file parallel write 32 32
45460 1 gcs log flush sync 32 2
45460 1 gc current block 2-way 32 124
45460 1 gc cr grant 2-way 32 3543
45460 1 LGWR wait for redo copy 32 36498
45460 2 log file sync 32 2250855
45460 2 log file switch completion 32 156976
45460 2 log file parallel write 32 26
45460 2 gc current block 2-way 32 130
45460 2 gc cr grant 2-way 32 182
45460 2 LGWR wait for redo copy 32 12471
45460 1 log file sync 64 38621
45460 1 log file switch completion 64 154263
45460 1 log file parallel write 64 2
45460 1 gc current block 2-way 64 80
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45460 1 gc cr grant 2-way 64 5744
45460 1 LGWR wait for redo copy 64 1047
45460 2 log file sync 64 144368
45460 2 log file switch completion 64 48961
45460 2 gc current block 2-way 64 4
45460 2 gc cr grant 2-way 64 13
45460 2 LGWR wait for redo copy 64 527
45460 1 wait for scn ack 128 1
45460 1 log file sync 128 6884
45460 1 log file switch completion 128 130
45460 1 log file parallel write 128 2
45460 1 gc current block 2-way 128 119
45460 1 gc cr grant 2-way 128 9121
45460 1 LGWR wait for redo copy 128 16
45460 2 log file sync 128 113877
45460 2 log file switch completion 128 39
45460 2 gc current block 2-way 128 1
45460 2 gc cr grant 2-way 128 9
45460 2 LGWR wait for redo copy 128 34
45460 1 wait for scn ack 256 1
45460 1 log file sync 256 863
45460 1 log file switch completion 256 20
45460 1 log file parallel write 256 4
45460 1 gc current block 2-way 256 101
45460 1 gc cr grant 2-way 256 7061
45460 1 LGWR wait for redo copy 256 3
45460 2 log file sync 256 661
45460 2 LGWR wait for redo copy 256 3
45460 1 wait for scn ack 512 3
45460 1 log file sync 512 399
45460 1 log file parallel write 512 1
45460 1 gc current block 2-way 512 17
45460 1 gc cr grant 2-way 512 4542
45460 2 log file sync 512 32
45460 1 wait for scn ack 1024 2
45460 1 log file sync 1024 590
45460 1 log file parallel write 1024 3
45460 1 gc current block 2-way 1024 1
45460 1 gc cr grant 2-way 1024 16
45460 2 log file sync 1024 14
45460 2 gc current block 2-way 1024 1
45460 1 log file sync 2048 47
45460 1 log file parallel write 2048 1
45460 1 gc cr grant 2-way 2048 2
45460 2 log file sync 2048 1
45460 1 log file sync 4096 39
45460 1 log file parallel write 4096 2
45460 2 log file parallel write 4096 2
45460 1 gc cr grant 2-way 8192 5
45461 1 log file sync .000976563 2
45461 1 gcs log flush sync .000976563 16877
45461 1 LGWR wait for redo copy .000976563 339004978
45461 2 gcs log flush sync .000976563 5154
45461 2 LGWR wait for redo copy .000976563 65082484
45461 1 log file sync .001953125 734
45461 1 log file switch completion .001953125 1
45461 1 gcs log flush sync .001953125 129887
45461 1 LGWR wait for redo copy .001953125 234370917
45461 2 log file sync .001953125 50
45461 2 log file switch completion .001953125 1
45461 2 gcs log flush sync .001953125 43296
45461 2 LGWR wait for redo copy .001953125 48722860
45461 1 log file sync .00390625 2220
45461 1 log file switch completion .00390625 5
45461 1 log file parallel write .00390625 35845
45461 1 gcs log flush sync .00390625 183838
45461 1 gc current block 2-way .00390625 1
45461 1 gc cr grant 2-way .00390625 539
45461 1 LGWR wait for redo copy .00390625 165575377
45461 2 wait for scn ack .00390625 2
45461 2 log file sync .00390625 950
45461 2 log file switch completion .00390625 1
45461 2 log file parallel write .00390625 4532
45461 2 gcs log flush sync .00390625 80230
45461 2 gc current block 2-way .00390625 1
45461 2 gc cr grant 2-way .00390625 18
45461 2 LGWR wait for redo copy .00390625 52878869
45461 1 log file sync .0078125 3002
45461 1 log file switch completion .0078125 17
45461 1 log file parallel write .0078125 1112648
45461 1 gcs log flush sync .0078125 238783
45461 1 gc current block 2-way .0078125 28809
45461 1 gc cr grant 2-way .0078125 210937
45461 1 LGWR wait for redo copy .0078125 1507241796
45461 2 log file sync .0078125 1304
45461 2 log file switch completion .0078125 7
45461 2 log file parallel write .0078125 247147
45461 2 gcs log flush sync .0078125 75635
45461 2 gc current block 2-way .0078125 13919
45461 2 gc cr grant 2-way .0078125 27160
45461 2 LGWR wait for redo copy .0078125 396050386
45461 1 log file sync .015625 76011
45461 1 log file switch completion .015625 8
45461 1 log file parallel write .015625 6788096555
45461 1 gcs log flush sync .015625 200661
45461 1 gc current block 2-way .015625 88185
45461 1 gc cr grant 2-way .015625 1306183
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45461 1 LGWR wait for redo copy .015625 9000187655
45461 2 wait for scn ack .015625 9
45461 2 log file sync .015625 4912
45461 2 log file switch completion .015625 1
45461 2 log file parallel write .015625 2298420268
45461 2 gcs log flush sync .015625 52435
45461 2 gc current block 2-way .015625 32006
45461 2 gc cr grant 2-way .015625 131573
45461 2 LGWR wait for redo copy .015625 1594313300
45461 1 log file sync .03125 262755
45461 1 log file switch completion .03125 1
45461 1 log file parallel write .03125 1.7618E+10
45461 1 gcs log flush sync .03125 143929
45461 1 gc current block 2-way .03125 8819491
45461 1 gc cr grant 2-way .03125 160490248
45461 1 LGWR wait for redo copy .03125 7470184716
45461 2 wait for scn ack .03125 13
45461 2 log file sync .03125 48483
45461 2 log file parallel write .03125 3448136221
45461 2 gcs log flush sync .03125 41006
45461 2 gc current block 2-way .03125 460872
45461 2 gc cr grant 2-way .03125 5591790
45461 2 LGWR wait for redo copy .03125 1289429208
45461 1 log file sync .0625 2429474206
45461 1 log file switch completion .0625 24
45461 1 log file parallel write .0625 4964778156
45461 1 gcs log flush sync .0625 407785
45461 1 gc current block 2-way .0625 166605911
45461 1 gc cr grant 2-way .0625 924759501
45461 1 LGWR wait for redo copy .0625 3214247923
45461 2 wait for scn ack .0625 14
45461 2 log file sync .0625 1828795616
45461 2 log file switch completion .0625 9
45461 2 log file parallel write .0625 1050332526
45461 2 gcs log flush sync .0625 109878
45461 2 gc current block 2-way .0625 75875054
45461 2 gc cr grant 2-way .0625 124077556
45461 2 LGWR wait for redo copy .0625 580404232
45461 1 log file sync .125 1433262891
45461 1 log file switch completion .125 288
45461 1 log file parallel write .125 1285822900
45461 1 gcs log flush sync .125 524407
45461 1 gc current block 2-way .125 28525372
45461 1 gc cr grant 2-way .125 166040526
45461 1 LGWR wait for redo copy .125 1797259418
45461 2 wait for scn ack .125 10
45461 2 log file sync .125 1091773042
45461 2 log file switch completion .125 147
45461 2 log file parallel write .125 136036461
45461 2 gcs log flush sync .125 90312
45461 2 gc current block 2-way .125 10938196
45461 2 gc cr grant 2-way .125 24194730
45461 2 LGWR wait for redo copy .125 331567390
45461 1 log file sync .25 821089208
45461 1 log file switch completion .25 1466
45461 1 log file parallel write .25 145730567
45461 1 gcs log flush sync .25 209682
45461 1 gc current block 2-way .25 1550328
45461 1 gc cr grant 2-way .25 13977014
45461 1 LGWR wait for redo copy .25 1117252109
45461 2 wait for scn ack .25 3
45461 2 log file sync .25 403485519
45461 2 log file switch completion .25 596
45461 2 log file parallel write .25 8191679
45461 2 gcs log flush sync .25 41744
45461 2 gc current block 2-way .25 629385
45461 2 gc cr grant 2-way .25 3014202
45461 2 LGWR wait for redo copy .25 293190989
45461 1 log file sync .5 396974833
45461 1 log file switch completion .5 3904
45461 1 log file parallel write .5 4251637
45461 1 gcs log flush sync .5 47604
45461 1 gc current block 2-way .5 368691
45461 1 gc cr grant 2-way .5 2297959
45461 1 LGWR wait for redo copy .5 588027027
45461 2 wait for scn ack .5 2
45461 2 log file sync .5 286256059
45461 2 log file switch completion .5 1682
45461 2 log file parallel write .5 1659267
45461 2 gcs log flush sync .5 24703
45461 2 gc current block 2-way .5 198606
45461 2 gc cr grant 2-way .5 532720
45461 2 LGWR wait for redo copy .5 73430371
45461 1 log file sync 1 128882255
45461 1 log file switch completion 1 7875
45461 1 log file parallel write 1 251881
45461 1 gcs log flush sync 1 10642
45461 1 gc current block 2-way 1 115132
45461 1 gc cr grant 2-way 1 854239
45461 1 LGWR wait for redo copy 1 137067465
45461 2 log file sync 1 101939203
45461 2 log file switch completion 1 3862
45461 2 log file parallel write 1 490489
45461 2 gcs log flush sync 1 16405
45461 2 gc current block 2-way 1 125460
45461 2 gc cr grant 2-way 1 255723
45461 2 LGWR wait for redo copy 1 2786857
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45461 1 log file sync 2 22089275
45461 1 log file switch completion 2 15866
45461 1 log file parallel write 2 42258
45461 1 gcs log flush sync 2 1284
45461 1 gc current block 2-way 2 39947
45461 1 gc cr grant 2-way 2 424154
45461 1 LGWR wait for redo copy 2 2672311
45461 2 log file sync 2 24562329
45461 2 log file switch completion 2 7727
45461 2 log file parallel write 2 127479
45461 2 gcs log flush sync 2 8865
45461 2 gc current block 2-way 2 20029
45461 2 gc cr grant 2-way 2 45909
45461 2 LGWR wait for redo copy 2 1295782
45461 1 log file sync 4 3228065
45461 1 log file switch completion 4 32130
45461 1 log file parallel write 4 7438
45461 1 gcs log flush sync 4 496
45461 1 gc current block 2-way 4 42595
45461 1 gc cr grant 2-way 4 453539
45461 1 LGWR wait for redo copy 4 697539
45461 2 log file sync 4 21625299
45461 2 log file switch completion 4 16184
45461 2 log file parallel write 4 11100
45461 2 gcs log flush sync 4 2804
45461 2 gc current block 2-way 4 12359
45461 2 gc cr grant 2-way 4 28049
45461 2 LGWR wait for redo copy 4 943188
45461 1 log file sync 8 2800045
45461 1 log file switch completion 8 65616
45461 1 log file parallel write 8 478
45461 1 gcs log flush sync 8 140
45461 1 gc current block 2-way 8 17803
45461 1 gc cr grant 2-way 8 155804
45461 1 LGWR wait for redo copy 8 421079
45461 2 log file sync 8 18224259
45461 2 log file switch completion 8 32815
45461 2 log file parallel write 8 251
45461 2 gcs log flush sync 8 545
45461 2 gc current block 2-way 8 5218
45461 2 gc cr grant 2-way 8 12094
45461 2 LGWR wait for redo copy 8 490408
45461 1 log file sync 16 1918062
45461 1 log file switch completion 16 137354
45461 1 log file parallel write 16 140
45461 1 gcs log flush sync 16 24
45461 1 gc current block 2-way 16 2775
45461 1 gc cr grant 2-way 16 25126
45461 1 LGWR wait for redo copy 16 229497
45461 2 log file sync 16 9677381
45461 2 log file switch completion 16 68894
45461 2 log file parallel write 16 17
45461 2 gcs log flush sync 16 68
45461 2 gc current block 2-way 16 1432
45461 2 gc cr grant 2-way 16 3106
45461 2 LGWR wait for redo copy 16 111086
45461 1 log file sync 32 491356
45461 1 log file switch completion 32 448692
45461 1 log file parallel write 32 32
45461 1 gcs log flush sync 32 2
45461 1 gc current block 2-way 32 124
45461 1 gc cr grant 2-way 32 3545
45461 1 LGWR wait for redo copy 32 36499
45461 2 log file sync 32 2250855
45461 2 log file switch completion 32 156981
45461 2 log file parallel write 32 26
45461 2 gc current block 2-way 32 130
45461 2 gc cr grant 2-way 32 182
45461 2 LGWR wait for redo copy 32 12471
45461 1 log file sync 64 38621
45461 1 log file switch completion 64 154336
45461 1 log file parallel write 64 2
45461 1 gc current block 2-way 64 80
45461 1 gc cr grant 2-way 64 5753
45461 1 LGWR wait for redo copy 64 1047
45461 2 log file sync 64 144368
45461 2 log file switch completion 64 48961
45461 2 gc current block 2-way 64 4
45461 2 gc cr grant 2-way 64 13
45461 2 LGWR wait for redo copy 64 527
45461 1 wait for scn ack 128 1
45461 1 log file sync 128 6886
45461 1 log file switch completion 128 130
45461 1 log file parallel write 128 2
45461 1 gc current block 2-way 128 119
45461 1 gc cr grant 2-way 128 9122
45461 1 LGWR wait for redo copy 128 16
45461 2 log file sync 128 113877
45461 2 log file switch completion 128 39
45461 2 gc current block 2-way 128 1
45461 2 gc cr grant 2-way 128 9
45461 2 LGWR wait for redo copy 128 34
45461 1 wait for scn ack 256 1
45461 1 log file sync 256 863
45461 1 log file switch completion 256 20
45461 1 log file parallel write 256 4
45461 1 gc current block 2-way 256 101
SNAP_ID INST NAME WAIT_TIME_MILLI WAIT_COUNT
---------- ---- ---------------------------------------- --------------- ----------
45461 1 gc cr grant 2-way 256 7065
45461 1 LGWR wait for redo copy 256 3
45461 2 log file sync 256 661
45461 2 LGWR wait for redo copy 256 3
45461 1 wait for scn ack 512 3
45461 1 log file sync 512 399
45461 1 log file parallel write 512 1
45461 1 gc current block 2-way 512 17
45461 1 gc cr grant 2-way 512 4545
45461 2 log file sync 512 32
45461 1 wait for scn ack 1024 2
45461 1 log file sync 1024 590
45461 1 log file parallel write 1024 3
45461 1 gc current block 2-way 1024 1
45461 1 gc cr grant 2-way 1024 16
45461 2 log file sync 1024 14
45461 2 gc current block 2-way 1024 1
45461 1 log file sync 2048 47
45461 1 log file parallel write 2048 1
45461 1 gc cr grant 2-way 2048 2
45461 2 log file sync 2048 1
45461 1 log file sync 4096 39
45461 1 log file parallel write 4096 2
45461 2 log file parallel write 4096 2
45461 1 gc cr grant 2-way 8192 5
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...
having avg(time_waited)/1000 > )
*
ERROR at line 9:
ORA-00936: missing expression
TIME
-----------------
Mar07 05:06:07
|
참조 : 1064487.1
WAITEVENT: "log file sync" Reference Note (Doc ID 34592.1)
'ORACLE > Sql' 카테고리의 다른 글
| 오라클 19c 기간별 세션 현황 확인 쿼리 (0) | 2023.07.29 |
|---|---|
| 오라클 19c v$로 시작하는 뷰 원본 쿼리 확인 (0) | 2023.07.13 |
| 오라클 19c 일별, 시간별 아카이브 갯수 및 용량 확인 (0) | 2022.08.08 |
| 오라클 19c undo 상세 정보 html 로 확인 쿼리 (0) | 2022.06.28 |
| 오라클 19c 테이블별 카운트 확인 쿼리(마이그레이션 검증용) (0) | 2022.03.14 |