Performance problem related with strange increase of physical writes
Hello all,
10.2.0.4 database running on a Windows x-64 machine.
Suddenly database performance dropped and only becomes again normal after reboot machine (including database of course) and storage system without any change in database neither application neither machine, operating neither storage system. Before that we tried rebooting database but performance did not improve.
I have compared with awr the problematic period and normal period (after reboot) and the main differences are:
a) Log File Sync: the main event wait in problematic period is log file sync: 40%
We know I/O perfomance dropped during performance period, so this is almost sure due to that.
10.2.0.4 database running on a Windows x-64 machine.
Suddenly database performance dropped and only becomes again normal after reboot machine (including database of course) and storage system without any change in database neither application neither machine, operating neither storage system. Before that we tried rebooting database but performance did not improve.
I have compared with awr the problematic period and normal period (after reboot) and the main differences are:
a) Log File Sync: the main event wait in problematic period is log file sync: 40%
We know I/O perfomance dropped during performance period, so this is almost sure due to that.
0