Query runs faster 2nd time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Query runs faster 2nd time

  1. #1
    Join Date
    Mar 2009
    Location
    SOCAL
    Posts
    4

    Query runs faster 2nd time

    I have a query (with lot of JOINS), which takes about 36 seconds first time and takes only 2 seconds second time. The same query runs with vendor env within 5 seconds first time itself.

    Any idea how to make the query runs faster even first time?

    It is AIX5.3/10.2.0.2

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Talking Parse + buffers

    1ts time - Parse query and load data buffers in memory
    2nd time - No parse and some or all data in memory
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Mar 2009
    Location
    SOCAL
    Posts
    4
    Thanks for the clarification but I wonder how it runs faster in vendor's site but not in our place. Is it because they have faster systems with more memory and CPU? Vendor not responded so far for their config.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    There could be various reasons for your two line question. Ask your DBAs to analyze AWR report to see the bottlenecks.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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