DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: About tuning sql queries!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    How to tune sql queries!

    Regards,


    Amit.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Start here and post more specific questions in another thread.
    http://technet.oracle.com/docs/produ...13_exp.htm#822
    Jeff Hunter

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Depending on the problem areas you deal with.

    1)Find who(User/Schema) is culprit for performance.
    2)Find what that specific user executing joining diffrent view for relevant info like V$SQLAREA,V$SYSSTATS, V$SESSIOn etc.,
    3)Start investigating the problem from there whats causing downgraded performance. Numerous number of reasons that affect SQL queries, to mention few...

    Poor code
    Optimizer mode
    inappropriate index use

    Use relevant tools like Explain Plan, TKPROF,ESTAT/BSTAT, STATSPACK(816+) to figure out problem area.

    Take necessary steps to tune SQL depending upon the problem areas.

    Tuning ideas;

    Use right index,hints
    Pin the objects used frequently
    Rewrite the code thats looping executions
    Change the optimizer mode
    Keep up to date statistics depending on the the optimizer mode etc.,


    Reddy,Sam

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    also make sure that they use the bind variables in the queries, which would drastically help on the loads.

    check dba_object_cache for more details

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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