1 2 Previous Next 17 Replies Latest reply: Jul 10, 2012 1:24 AM by user3240461 RSS

    alert log message "Private strand flush not complete"

    user3240461
      we are facing the subject error in one our dataware house database 11gR2 grid standalone, database is in noarichive mode.
      according to metalink ID-372557.1 "These messages are not a cause for concern unless there is a significant gap in seq# between the “cannot allocate new log” message and the “advanced to log sequence” message.

      -- *The gap is 1 to 2 minute in our case.*

      This issue is infact not a bug and is expected behavior.

      In some cases, this message can be resolved by increasing db_writer_process value. "

      -- db_writer_process =8 in our case.

      Edited by: user3240461 on Jul 8, 2012 2:14 AM
        • 1. Re: alert log message "Private strand flush not complete"
          Osama_Mustafa
          Welcome to OTN


          i suggest to Open SR .


          Osama ...
          • 4. Re: alert log message "Private strand flush not complete"
            user3240461
            dear osama, i am new to this forum, how i can open service request.
            • 5. Re: alert log message "Private strand flush not complete"
              Osama_Mustafa
              user3240461 wrote:
              dear osama, i am new to this forum, how i can open service request.
              first you must have metalink account
              -go to support.oracle.come
              -under service request tab .you will find create service request .
              -Create it and follow the steps .


              Osama ...
              • 6. Re: alert log message "Private strand flush not complete"
                user3240461
                need help on urgent basis, problem is still not resolved
                • 7. Re: alert log message "Private strand flush not complete"
                  Girish Sharma
                  Are you seeing some issues other than this message in the db ? If yes then post them here, else just ignore because these messages are not a cause for concern unless there is a significant gap in seq# between the "cannot allocate new log" message and the "advanced to log sequence" message.

                  Source:http://www.orafaq.com/forum/t/122199/0/
                  • 8. Re: alert log message "Private strand flush not complete"
                    user3240461
                    our dataware house database is too slow to responce. Private strand flush not complete is coming after 1 or 2 minutes
                    i have add and resize redo logs, and now current size is 1.7gb.
                    log_buffer size is 33M, while in our another 10g database log_buffer size 4M. And its working.
                    RAM is 32g and server has one physical processor has 64 virtual processors (0-63) UltraSPARC-T2 (chipid 0, clock 1165 MHz)

                    i am confused about the cpu speed, i think the problem is due to cpu, becuase we have one physical processor.
                    below are system statistics:
                    SNAME     PNAME     PVAL1     PVAL2
                    SYSSTATS_INFO     STATUS          COMPLETED
                    SYSSTATS_INFO     DSTART          07-08-2012 13:00
                    SYSSTATS_INFO     DSTOP          07-09-2012 05:41
                    SYSSTATS_INFO     FLAGS     1     
                    SYSSTATS_MAIN     CPUSPEEDNW     714     
                    SYSSTATS_MAIN     IOSEEKTIM     10     
                    SYSSTATS_MAIN     IOTFRSPEED     4,096     
                    SYSSTATS_MAIN     SREADTIM     0     
                    SYSSTATS_MAIN     MREADTIM     3,248     
                    SYSSTATS_MAIN     CPUSPEED     312     
                    SYSSTATS_MAIN     MBRC     16     
                    SYSSTATS_MAIN     MAXTHR     368,645,120     
                    SYSSTATS_MAIN     SLAVETHR     83,968
                    • 9. Re: alert log message "Private strand flush not complete"
                      Girish Sharma
                      No, I don't think that there is any considerable issue with CPU statistics which you provided for this message. If you still feel that its something with CPU then please check below link :
                      http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:67994814192949

                      1.Post the output of select * from v$version;
                      2.OS info
                      3.select l.group#, lf.member, l.bytes/1024/1024 mb, l.status, l.archived
                      from v$logfile lf, v$log l
                      where l.group# = lf.group#
                      order by 1, 2;
                      4.Are there some datafile which are not autoextended ? Because since its a message only, not a warning or a bug or an error, whose sense is user sessions trying to generate redo, wait on this event when LGWR waits for DBWR to complete flushing redo from IMU buffers into the log buffer; when DBWR is complete LGWR can then finish writing the current log, and then switch log files.
                      • 10. Re: alert log message "Private strand flush not complete"
                        anand prakash - oracle
                        Hi,

                        As this message means that we haven't completed writing all the redo information to the log when we are trying to switch, you can tell us how many redo log groups are the there and whats the size of the member? Are the redo log files on slower disk? You need to check disk performance too where redo logfiles and datafiles are stored. What are the top-5 wait events from AWR?


                        Anand
                        • 11. Re: alert log message "Private strand flush not complete"
                          user3240461
                          1. select * from v$version;
                          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit

                          2. os version = 5.10 Generic_144488-09 sun4v sparc SUNW,Sun-Blade-T6320

                          3. select l.group#, lf.member, l.bytes/1024/1024 mb, l.status, l.archived from v$logfile lf, v$log l
                          where l.group# = lf.group# order by 1, 2;

                          GROUP#     MEMBER     MB     STATUS     ARCHIVED
                          1     +DATA1/finc/onlinelog/group_1.258.787920895     200     INACTIVE     NO
                          1     +DATA1/finc/onlinelog/group_1.261.787920953     200     INACTIVE     NO
                          2     +DATA2/finc/onlinelog/group_2.272.788019709     200     INACTIVE     NO
                          2     +DATA2/finc/onlinelog/group_2.274.788019729     200     INACTIVE     NO
                          3     +DATA2/finc/onlinelog/group_3.275.788019737     200     INACTIVE     NO
                          3     +DATA2/finc/onlinelog/group_3.276.788019743     200     INACTIVE     NO
                          4     +DATA1/finc/onlinelog/group_4.273.787921255     200     INACTIVE     NO
                          4     +DATA1/finc/onlinelog/group_4.274.787921265     200     INACTIVE     NO
                          5     +DATA2/finc/onlinelog/group_5.268.788018911     200     INACTIVE     NO
                          5     +DATA2/finc/onlinelog/group_5.269.788018927     200     INACTIVE     NO
                          6     +DATA2/finc/onlinelog/group_6.270.788018935     200     CURRENT     NO
                          6     +DATA2/finc/onlinelog/group_6.271.788018943     200     CURRENT     NO
                          6     +DATA2/finc/onlinelog/group_6.273.788019717     200     CURRENT     NO
                          7     +DATA2/finc/onlinelog/group_7.277.788023645     500     INACTIVE     NO
                          7     +DATA2/finc/onlinelog/group_7.278.788023657     500     INACTIVE     NO

                          4. datafiles are autoextend
                          *all datafiles, tem and undo data files are big files.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                          • 12. Re: alert log message "Private strand flush not complete"
                            user3240461
                            i have created all the tablespace with the below commands. database block is 8kb, while i have created tablespace with nonstandard block size 16kb for our dataware house.

                            create bigfile tablespace test datafile '+DATA2' size 100g autoextend on next 10M blocksize 16k;
                            • 13. Re: alert log message "Private strand flush not complete"
                              Aman....
                              I don't think that the tablespace has anything to do with it. The message is related to the redo data that's stored in the shared pool. As Anand has asked, post the result of the top five timed events as that would reflect more clear picture.

                              Aman....
                              • 14. Re: alert log message "Private strand flush not complete"
                                user3240461
                                anand, aman, can u please share with me the query to post the result of the top five timed events as that would reflect more clear picture.
                                1 2 Previous Next