Oracle sql performance tunning tips 2012-01-04

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