Problem With a Query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problem With a Query

  1. #1
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103

    Problem With a Query

    Hai All.
    I have a Query that is showing about 456 consistent gets, using SQLTRACE, when I'm executing as a single user. But, when we are doing a Load Test, we are seeing lot of Logical Reads, about 95,233.0 Buffer Gets per single execution from Statspack. So, I would like to have your advices. The following are the details of the Query. Please help me.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    do they share same execution plan?

  3. #3
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    Ofourse they should be using the same execution plan as it the same query which is being used. Ofcourse we don't get the execution plan in the Statspack Report. But, how do we know if it's the same execution plan being used or not as the Query is being fired from our Web Application. Is there any way by whcih we could improve the Query.

    Ofcourse inspite of that I can always see atleast 850MB free memory in our Buffer Cache afetr the test. But, this Query probably is increasing the response times of all others also in our test.

    regards,
    Dileep T.V.R.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    I may guess that the explain plan in sqlplus differs from the tkprof which tells correct execution plan.
    You can post the tkprof output here.

    Also, post the statspack report.

    Tamil

Posting Permissions

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



Click Here to Expand Forum to Full Width