-
How to tune sql queries!
Regards,
Amit.
-
Start here and post more specific questions in another thread.
http://technet.oracle.com/docs/produ...13_exp.htm#822
Jeff Hunter
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|