8 Replies Latest reply: Feb 12, 2013 6:28 AM by Osama_Mustafa RSS

    Real application testing

    Pavel
      Hello!

      My question releted Real application testing
      Please let me now , the loading of "replaying" server increases in proportion to number of client connections ?
      For what it is used more than one wrc connection ?

      Thanks and regards,
      Pavel
        • 1. Re: Real application testing
          Justin_Mungal
          Pavel wrote:
          Hello!

          My question releted Real application testing
          Please let me now , the loading of "replaying" server increases in proportion to number of client connections ?
          If I understand you correctly, you're asking if RAT re-creates the same amount of connections during the replay. If so, the answer is yes, with some restrictions.

          After a captured workload has been preprocessed, it can be replayed on a test system. During the workload replay phase, Oracle Database performs the actions recorded during the workload capture phase on the test system by re-creating all captured external client requests with the same timing, concurrency, and transaction dependencies of the production system.

          The following types of client requests are not captured in a workload:

          Direct path load of data from external files using utilities such as SQL*Loader
          Non-PL/SQL based Advanced Queuing (AQ)
          Flashback queries
          Oracle Call Interface (OCI) based object navigations
          Non SQL-based object access
          Distributed transactions (any distributed transactions that are captured will be replayed as local transactions)

          References:
          http://docs.oracle.com/cd/E11882_01/server.112/e16540/dbr_intro.htm#CHDEIEGD
          http://docs.oracle.com/cd/E11882_01/server.112/e16540/dbr_capture.htm#CACCBADG
          For what it is used more than one wrc connection ?
          I don't know what you mean.

          -Justin
          • 2. Re: Real application testing
            Pavel
            Hello Justin

            I have asking about connection from the wrc client program

            Regards ,
            Pavel
            • 3. Re: Real application testing
              Justin_Mungal
              Hi Pavel,

              One replay client can initiate multiple sessions.

              -Justin
              • 4. Re: Real application testing
                Pavel
                Hi Justin

                Thanks.
                If two clients was started duble volume of workload played ?

                Regards,
                Pavel
                • 5. Re: Real application testing
                  Osama_Mustafa
                  What is wrc program ? i try to google it but nothing
                  • 6. Re: Real application testing
                    Pavel
                    Hello

                    wrc - workload replay client , Sir

                    Regards,
                    Pavel
                    • 7. Re: Real application testing
                      Justin_Mungal
                      Pavel wrote:
                      Hi Justin

                      Thanks.
                      If two clients was started duble volume of workload played ?

                      Regards,
                      Pavel
                      No, that is not how it works. But, you may need multiple replay clients depending on the volume of workload captured. Please read the documentation Pavel, so that you can understand how replay clients work.
                      http://docs.oracle.com/cd/E11882_01/server.112/e16540/dbr_replay.htm#CHDBCADJ

                      -Justin
                      • 8. Re: Real application testing
                        Osama_Mustafa
                        You can check this below link
                        http://taliphakanozturken.wordpress.com/tag/workload-replay-client/