CPU spikes on Database performance
I have Oracle RAC 19c infrastructure 2 nodes on LUNIX 7 Database 19.3.
On daily basis between 12 and 12:10am the infrastructure team notices CPU spikes and tonday it reaches 100% on one of the nodes (node 2 ) for 5 mintues and it dropped back to normal.
knowing that now database RMAN backup is running at that time, only archivelog backup job is running but again its running every 2 hours but only big spikes is noticed between 12 and 12:10
REDOLOG switches was 1 within 1 hours (11-12) and (12-1) so no excessive log switching
AWR reports shows nothing abnormal and the DB health was good, (the AWR is for 30 minutes) so we couldnt catch exactly what happened at 12
On daily basis between 12 and 12:10am the infrastructure team notices CPU spikes and tonday it reaches 100% on one of the nodes (node 2 ) for 5 mintues and it dropped back to normal.
knowing that now database RMAN backup is running at that time, only archivelog backup job is running but again its running every 2 hours but only big spikes is noticed between 12 and 12:10
REDOLOG switches was 1 within 1 hours (11-12) and (12-1) so no excessive log switching
AWR reports shows nothing abnormal and the DB health was good, (the AWR is for 30 minutes) so we couldnt catch exactly what happened at 12
Tagged:
0