Monday, August 10, 2015

DATABASE TUNNING- Using SQL Trace and TKPROF

                    DATABASE TUNING

Database Tuning : Database tuning is the process/steps which will help to improve the Database performance. If the database performed well then Application will worked  smoothly.

Types of Database Tuning: 

1.      Database Tuning
2.      SQL Tuning

Database Tuning :

              It’s performed by DBA. Database tuning need to performed in DB hardware and server side.

SQL Tuning: 

No comments:

Post a Comment

Installation of Oracle 11g and 12c *Kindly see the You Tube video to get installed the database.