1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
kartickaity02

Oracle sql performance tunning tips 2012-01-04

Oracle sql performance tunning tips

  1. kartickaity02
    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