Performance tuning is nothing but the collection of statistics regarding the current status of the system and then change system values based on the statistics to enhance the performance. In other words performance tuning is
1. Collection of system statistics
2. Changing system based on the statistics
We tune the database regularly for optimal performance. The following are the tuning areas, where we are concentrating to tune the database
1. Memory Tuning
2. SQL Tuning
3. Database level Tuning
This Document provides some good tips on SQL tuning
-
Get unlimited access to documents by upgrading to Premium Membership.
-
We are not accepting new members currently. If you would like to join, please contact us.Dismiss Notice
Oracle sql performance tunning tips 2012-01-04
Oracle sql performance tunning tips