This discussion is archived
8 Replies Latest reply: Feb 12, 2013 4:28 AM by Osama_Mustafa RSS

Real application testing

Pavel Explorer
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    Hello Justin

    I have asking about connection from the wrc client program

    Regards ,
    Pavel
  • 3. Re: Real application testing
    Justin_Mungal Journeyer
    Currently Being Moderated
    Hi Pavel,

    One replay client can initiate multiple sessions.

    -Justin
  • 4. Re: Real application testing
    Pavel Explorer
    Currently Being Moderated
    Hi Justin

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

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

    wrc - workload replay client , Sir

    Regards,
    Pavel
  • 7. Re: Real application testing
    Justin_Mungal Journeyer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    You can check this below link
    http://taliphakanozturken.wordpress.com/tag/workload-replay-client/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points