Recent network environment undo tablespace is too high, now see who runs awr found user/IO is high, the db file sequential read wait is very much also,

Yesterday, increasing the Buffer Cache, the effect also is not very detailed,

Ask next, is there any space can be optimized
https://download.csdn.net/download/qq_36569606/13124265

CodePudding user response:

1. Low version 11.2.0.1, need to add some implicit parameter
2. The top SQL should need to optimize
3. Other needs further analysis

CodePudding user response:

Thank you,
In addition to delete the delete table today (about 15 g) found that gets stuck, unable to delete,,
The alarm log is as follows:

 Fatal NI connect error 12537, connecting to: 
(LOCAL=NO) 

The 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 
NT TCP/IP 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 always the allocate new log, a sequence of 7207 
Private strand flush the not complete 
Current log# 17 seq# 7206 mem# 0:/home/oracle/app/oracle/oradata/former/redo17 log 
Thread 1 advanced to log sequence 7207 (LGWR switch) 
Current log# 5 seq# 7207 mem# 0:/home/oracle/app/oracle/oradata/former/redo05 log 
Thu Nov 19 16:29:41 2020 
Thread 1 always the allocate new log, a sequence of 7208 
Private strand flush the not complete 
Current log# 5 seq# 7207 mem# 0:/home/oracle/app/oracle/oradata/former/redo05 log 
Thread 1 advanced to log sequence 7208 (LGWR switch) 
Current log# 6 seq# 7208 mem# 0:/home/oracle/app/oracle/oradata/former/redo06 log 
Thu Nov 19 16:45:26 2020 
Thread 1 always the allocate new log, a sequence of 7209 
Private strand flush the not complete 
Current log# 6 seq# 7208 mem# 0:/home/oracle/app/oracle/oradata/former/redo06 log 
Thread 1 advanced to log sequence 7209 (LGWR switch) 
Current log# 15 seq# 7209 mem# 0:/home/oracle/app/oracle/oradata/former/redo15 log 
Thu Nov 19 17:01:20 2020 
Thread 1 always the allocate new log, a sequence of 7210 
Private strand flush the not complete 
Current log# 15 seq# 7209 mem# 0:/home/oracle/app/oracle/oradata/former/redo15 log 
Thread 1 advanced to log sequence 7210 (LGWR switch) 
Current log# 16 seq# 7210 mem# 0:/home/oracle/app/oracle/oradata/former/redo16 log 

CodePudding user response:

Is I need redo log switch problem or how to operate