Why and when should one tune?
Submitted by admin on Sun, 2005-12-25 12:54.
One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance.
One should do performance tuning for the following reasons:
- The speed of computing might be wasting valuable human time (users waiting for response);
- Enable your system to keep-up with the speed business is conducted; and
- Optimize hardware usage to save money (companies are spending millions on hardware).
Although this site is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.
»
- Login to post comments
Tunning the database with the help of hit ratios
Hi Naseem,
Hit ratios can provide you false information also. I have seen that sometime ratio is 0 (ideal is 90% + ) But database was working nicely no any performance issue. So at least i am strongly against it.
The practical approach is ....
1. First catch the queries whcih are consuming the resources.
2. Than use any method ( trace, plan table etc )to see the exact reason.
3. Now decide what should be done.
(In many cases FTS is the main reason of performance degradation.)
you have many other methods also
like O.S. commmand, Statspack report, RDA report and some dynamic views like v$sysstat, v$session, v$sqlarea etc.
Regards
Sanjay