7 Replies Latest reply on Feb 18, 2013 2:12 PM by user12050217

    Doc confusion please

    user12050217
      Hi,

      I am reading below link :
      http://docs.oracle.com/cd/E11882_01/server.112/e25513/waitevents002.htm#i970852

      and not getting what is break? parameter of command wait parameter.
      I am not getting the meaning of "If the value for this parameter equals 0, a reset was sent to the client. A nonzero value indicates that a break was sent to the client."
      where to see this value, and what is its mean ?

      Please elaborate it.
        • 1. Re: Doc confusion please
          Fran
          Please elaborate it.
          http://www.adp-gmbh.ch/ora/sqlplus/break.html

          search "break" in sqlplus at google and you will find everything you need.
          • 2. Re: Doc confusion please
            user12050217
            Fran wrote:
            Please elaborate it.
            http://www.adp-gmbh.ch/ora/sqlplus/break.html

            search "break" in sqlplus at google and you will find everything you need.
            I am confused, how my question is related to sqlplus's break command. I am asking break parameter of Common Wait Event Parameters please.
            • 3. Re: Doc confusion please
              Fran
              http://www.pafumi.net/Wait_Events.html
              http://www.akadia.com/download/documents/session_wait_events.pdf
              http://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/oracle_database_wait_bottlenecks_net_reset_to_client_pct.html
              1 person found this helpful
              • 4. Re: Doc confusion please
                JohnWatson
                user12050217 wrote:
                Hi,

                I am reading below link :
                http://docs.oracle.com/cd/E11882_01/server.112/e25513/waitevents002.htm#i970852

                and not getting what is break? parameter of command wait parameter.
                I am not getting the meaning of "If the value for this parameter equals 0, a reset was sent to the client. A nonzero value indicates that a break was sent to the client."
                where to see this value, and what is its mean ?

                Please elaborate it.
                There are two wait events with a parameter of break?,
                orcl> select name from v$event_name where parameter2='break?';
                
                NAME
                ----------------------------------------------------------------
                SQL*Net break/reset to client
                SQL*Net break/reset to dblink
                
                orcl>
                orcl>
                so if you ever get either of those (unlikely) the value of p2 in v$session_wait will be 0.
                --
                John Watson
                Oracle Certified Master DBA
                http://skillbuilders.com
                1 person found this helpful
                • 5. Re: Doc confusion please
                  Girish Sharma
                  And in addition of what John has said please see below text from link :

                  [url http://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/oracle_database_wait_bottlenecks_net_reset_to_client_pct.html]SQL*Net break/reset to client (%)

                  If the value, v$session_wait.p2, for this parameter equals 0, it means a reset was sent to the client. A non-zero value means that the break was sent to the client.

                  And if you wish to see the code in action then see below link :
                  http://blog.tanelpoder.com/2008/04/10/sqlnet-breakreset-to-client/

                  Regards
                  Girish Sharma
                  • 6. Re: Doc confusion please
                    Jan-Marten Spit
                    a break is sent to the client when the client is expecting something from the database, but the database cannot deliver due to an error condition - which it needs to inform the client about. in effect, a break/reset is an error code going from server to client.
                    1 person found this helpful
                    • 7. Re: Doc confusion please
                      user12050217
                      Thanks to all of you.