SYS_AUTO_SQL_TUNING_TASK
938302Feb 14 2013 — edited Feb 14 2013He team,
I have a DB. 11.1.0.7 on Unix, And I have performance problem, In the alert log, I can see:
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Wed Feb 13 23:00:17 2013
Thread 1 cannot allocate new log, sequence 9303
Private strand flush not complete
Current log# 2 seq# 9302 mem# 0: /fredoA/PROD101/redo2A.log
Current log# 2 seq# 9302 mem# 1: /fredoB/PROD101/redo2B.log
Thread 1 advanced to log sequence 9303 (LGWR switch)
Current log# 3 seq# 9303 mem# 0: /fredoA/PROD101/redo3A.log
Current log# 3 seq# 9303 mem# 1: /fredoB/PROD101/redo3B.log
Wed Feb 13 23:00:33 2013
Archived Log entry 9276 added for thread 1 sequence 9302 ID 0xc17c6f08 dest 1:
Wed Feb 13 23:31:54 2013
AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail
Wed Feb 13 23:32:52 2013
AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail
Wed Feb 13 23:35:12 2013
AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail
Wed Feb 13 23:36:00 2013
AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail
Thu Feb 14 00:11:11 2013}
Regards,
Guido