Hello,
experts
I have a oracle DB 10.2.0.4.0 on AIX and I found there is 'log file sync' on TOP 5 timed events from AWR.See my 3 snapshot as follows,
Afterwards, I have also checked the situation of 'log file sync' and 'log file parallel write' from 14:00 to 14:34 during that time period with view DBA_HIST_ACTIVE_SESS_HISTORY,
SQL> select event, to_char(sample_time,'hh24:mi:ss'), to_char(round(time_waited/1000,2),'fm99999900.00')
2 from dba_hist_active_sess_history a
3 where a.sample_time>to_date('2018-01-29 14:00:00','yyyy-mm-dd hh24:mi:ss') and
4 a.sample_time<to_date('2018-01-29 14:34:00','yyyy-mm-dd hh24:mi:ss') and a.event='log file sync'
5 order by sample_time;
EVENT TO_CHAR( TO_CHAR(ROUN
------------------------------ -------- ------------
log file sync 14:17:20 07.67
log file sync 14:18:40 97.67
log file sync 14:18:40 97.66
log file sync 14:18:40 97.66
log file sync 14:18:40 97.67
log file sync 14:18:40 97.67
log file sync 14:18:40 97.67
log file sync 14:18:40 97.66
log file sync 14:18:50 97.66
log file sync 14:18:50 97.66
log file sync 14:18:50 97.67
log file sync 14:18:50 97.67
log file sync 14:18:50 97.67
log file sync 14:18:50 97.67
log file sync 14:18:50 97.69
log file sync 14:18:50 97.67
log file sync 14:18:50 97.66
......
log file sync 14:33:53 97.67
log file sync 14:33:53 97.66
log file sync 14:33:53 97.66
log file sync 14:33:53 97.66
log file sync 14:33:53 97.67
log file sync 14:33:53 97.67
log file sync 14:33:53 97.66
log file sync 14:33:53 97.67
log file sync 14:33:53 97.67
log file sync 14:33:53 97.67
log file sync 14:33:53 97.66
3437 rows selected.
SQL> select event, to_char(sample_time,'hh24:mi:ss'), to_char(round(time_waited/1000,2),'fm99999900.00')
2 from dba_hist_active_sess_history a
3 where a.sample_time>to_date('2018-01-29 14:00:00','yyyy-mm-dd hh24:mi:ss') and
4 a.sample_time<to_date('2018-01-29 14:34:00','yyyy-mm-dd hh24:mi:ss') and a.event='log file parallel write'
5 order by sample_time;
EVENT TO_CHAR( TO_CHAR(ROUN
------------------------- -------- ------------
log file parallel write 14:16:30 13.53
log file parallel write 14:17:20 08.24
log file parallel write 14:18:40 00.00
log file parallel write 14:18:50 00.00
log file parallel write 14:20:11 00.00
log file parallel write 14:20:21 00.00
log file parallel write 14:20:31 00.00
log file parallel write 14:25:42 00.00
log file parallel write 14:25:52 00.00
log file parallel write 14:26:02 00.00
log file parallel write 14:26:12 00.00
log file parallel write 14:26:22 00.00
log file parallel write 14:26:32 00.00
log file parallel write 14:26:42 00.00
log file parallel write 14:26:52 00.00
log file parallel write 14:27:02 00.00
log file parallel write 14:27:12 00.00
log file parallel write 14:27:22 00.00
log file parallel write 14:27:32 00.00
log file parallel write 14:27:42 00.00
log file parallel write 14:27:52 00.00
log file parallel write 14:28:02 00.00
log file parallel write 14:28:12 00.00
log file parallel write 14:28:22 00.00
log file parallel write 14:28:32 00.00
log file parallel write 14:28:42 00.00
log file parallel write 14:28:52 00.00
log file parallel write 14:29:02 00.00
log file parallel write 14:29:12 00.00
log file parallel write 14:29:22 00.00
log file parallel write 14:29:32 00.00
log file parallel write 14:29:42 00.00
log file parallel write 14:29:52 00.00
log file parallel write 14:30:02 00.00
log file parallel write 14:30:12 00.00
log file parallel write 14:30:22 00.00
log file parallel write 14:30:32 00.00
log file parallel write 14:30:42 00.00
log file parallel write 14:30:52 00.00
log file parallel write 14:31:02 00.00
log file parallel write 14:31:12 00.00
log file parallel write 14:31:23 00.00
log file parallel write 14:31:33 00.00
log file parallel write 14:31:43 00.00
log file parallel write 14:31:53 00.00
log file parallel write 14:32:03 00.00
log file parallel write 14:32:13 00.00
log file parallel write 14:32:23 00.00
log file parallel write 14:32:33 00.00
log file parallel write 14:32:43 00.00
log file parallel write 14:32:53 00.00
log file parallel write 14:33:03 00.00
log file parallel write 14:33:13 00.00
log file parallel write 14:33:23 00.00
log file parallel write 14:33:33 00.00
log file parallel write 14:33:43 00.00
log file parallel write 14:33:53 00.00
57 rows selected.
Next step, how to analyze for me continuously? Thanks a lot.
Best Regards
Quanwen Zhao