Oracle Performance 11g

Oracle Performance 11g - Warning: log write elapsed time

This question is Not Answered.

dharm.singh Jul 25, 2013 4:22 AM

Hello ,

We are facing quite bad performance with our SAP cluster running Oracle 11g .

In the ora alert file we are having constant message for "

Thread 1 cannot allocate new log, sequence xxxxxx

Private strand flush not complete"

However , this seems to be quite old as we have recently started facing the performace issue.

Moreover , in the sid_lgwr_788.trc file we are getting warning for log write elapsed time as follow.

 

*** 2013-07-25 08:43:07.098
Warning: log write elapsed time 722ms, size 4KB

*** 2013-07-25 08:44:07.069
Warning: log write elapsed time 741ms, size 32KB

*** 2013-07-25 08:44:11.134
Warning: log write elapsed time 1130ms, size 23KB

*** 2013-07-25 08:44:15.508
Warning: log write elapsed time 1161ms, size 25KB

*** 2013-07-25 08:44:19.790
Warning: log write elapsed time 1210ms, size 10KB

*** 2013-07-25 08:44:20.748
Warning: log write elapsed time 544ms, size 3KB

*** 2013-07-25 08:44:24.396
Warning: log write elapsed time 1104ms, size 14KB

*** 2013-07-25 08:44:28.955
Warning: log write elapsed time 1032ms, size 37KB

*** 2013-07-25 08:45:13.115
Warning: log write elapsed time 1096ms, size 3KB

*** 2013-07-25 08:45:46.995
Warning: log write elapsed time 539ms, size 938KB

*** 2013-07-25 08:47:55.424
Warning: log write elapsed time 867ms, size 566KB

*** 2013-07-25 08:48:00.288
Warning: log write elapsed time 871ms, size 392KB

*** 2013-07-25 08:48:04.514
Warning: log write elapsed time 672ms, size 2KB

*** 2013-07-25 08:48:08.788
Warning: log write elapsed time 745ms, size 466KB

 

Please advice to further understand the issue.

 

Regards