Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003

    Unanswered: Parsing queries after SGA flush

    We test an oracle 8i database with LoadRunner tools, launching scenario with 50 users, executing the sames scripts.

    Before testing a scenario, we flush the SGA.
    We test loading database with 50 users executing the same scenario.

    I hope some queries to be reused without parsing, but even for dynamical queries, number or execution and number of parse is the same.

    Could someone explain me what's happened ?

  2. #2
    Join Date
    May 2004
    Dominican Republic
    If you could tell us how are you writting your dynamic sql statement. For one, constructing sql statements on the go shouldn't be considered dynamic sql.

  3. #3
    Join Date
    Aug 2003
    Dynamic queries looks like
    select fields1, fields2, fields3
    from mytable
    where fields1=:a

    I don't know how they are created. I don't develop this application.

    My work is to test application performance, to explain bottlenecks and preconization.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts