tuning
how to go about tuning an oracle database.
any easy to use third-party tools that can be used by a oracle developer.any url's that answer oracle questions.what are oracle's tools.list good tuning tips.this will help.
thanks in advance.
Networks
how to go about tuning an oracle database.
any easy to use third-party tools that can be used by a oracle developer.any url's that answer oracle questions.what are oracle's tools.list good tuning tips.this will help.
thanks in advance.
by steveford
I would advise you to register with Oracle MetaLink to access information about all manner of Oracle issues including tuning. You can do this at metalink.oracle.com although you will need you Oracle Support Access Code (SAC) to do this.
Your first job is to decide what you want to tune and why. For this, gather information from users on their perception of areas of 'poor' performance. This should help you to identify some 'problem' queries or at least some times of the day or areas of work which require particular attention.
Having identified problem queries, use EXPLAIN PLAN and TKPROF (see Oracle Docs or Metalink for info) to identify the execution plan being used and see if indexes aren't being used or perhaps are missing.
Another approach is to use the bstat/estat scripts to generate a report which reports on a wide range of system statistics (again more info in Oracle Docs and a very good article on Metalink describing how to interpret the report)
As far as tools go, I don't tend to use any but I believe Oracle Expert (ok not 3rd party!) is a good aid when beginning to tune databases.
A good starting point for info in addition to MetaLink is the Oracle Performance Tuning manual.
In general terms, I would start with tuning the SQL issued by your application, if appropriate, since the biggest gains are to be found here in terms of poorly written SQL, missing or inappropriate indexes etc...
Other sources of Oracle info are;
Lazydba.com
http://www.ixora.com.au/home.htm
http://www.verge-tech.com/verge/olinks.htm
Hope this is of some help.
Steve.
by kinnu
by kinnu
This discussion is closed to new replies.
Sort by Trending