oracle数据库经常卡顿

背景：oracle数据库长时间很卡，业务量又比较大
解决思路：查看alert日志，发现经常报错：
Fri Jan 22 09:27:47 2021
Thread 1 cannot allocate new log, sequence 5730
Private strand flush not complete
原因：redo Log经常checkpoint导致数据库卡顿，增大redolog 即可
解决方法:
先查看redolog的组和大小
select group#,thread#,bytes/1024/1024||‘MB’ from v$log;

发现是50M太小了 于是增大redolog
查看redo log的日志路径
select MEMBER from vKaTeX parse error: Expected 'EOF', got '#' at position 390: …g组 select group#̲,members,bytes/…log;
GROUP# MEMBERS BYTES/1024/1024 STATUS
然后删除原有redo log日志
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;