近期現網環境undo表空間過高，查看awr發現user/io也高，db file sequential read等待也很多。
昨天加大了Buffer Cache，感覺效果也不太明細。
問下各位大佬還有可優化的空間嗎
https://download.csdn.net/download/qq_36569606/13124265
uj5u.com熱心網友回復：
1.版本低11.2.0.1，需要添加一些隱含引數2.top sql應該需要優化
3.其它需進一步分析
uj5u.com熱心網友回復：
感謝回復。另外今天洗掉delete表（15g左右）發現卡住，無法洗掉。。
告警日志如下：
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 19-NOV-2020 16:00:04
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (69163) as a result of ORA-609
Thu Nov 19 16:14:14 2020
Thread 1 cannot allocate new log, sequence 7207
Private strand flush not complete
Current log# 17 seq# 7206 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo17.log
Thread 1 advanced to log sequence 7207 (LGWR switch)
Current log# 5 seq# 7207 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo05.log
Thu Nov 19 16:29:41 2020
Thread 1 cannot allocate new log, sequence 7208
Private strand flush not complete
Current log# 5 seq# 7207 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo05.log
Thread 1 advanced to log sequence 7208 (LGWR switch)
Current log# 6 seq# 7208 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo06.log
Thu Nov 19 16:45:26 2020
Thread 1 cannot allocate new log, sequence 7209
Private strand flush not complete
Current log# 6 seq# 7208 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo06.log
Thread 1 advanced to log sequence 7209 (LGWR switch)
Current log# 15 seq# 7209 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo15.log
Thu Nov 19 17:01:20 2020
Thread 1 cannot allocate new log, sequence 7210
Private strand flush not complete
Current log# 15 seq# 7209 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo15.log
Thread 1 advanced to log sequence 7210 (LGWR switch)
Current log# 16 seq# 7210 mem# 0: /home/oracle/app/oracle/oradata/orcl/redo16.log
uj5u.com熱心網友回復：
是我的redo日志切換問題還是需要怎么操作轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/225110.html
標籤：基礎和管理
上一篇：oracle獲取欄位名