What is Performance Tuning?
Tools Every Tuner Must Know
Our performance tuners have the years of experience needed to analyze your performance issues. We provide documented recommendations to your DBA and can assist with the changes if needed. We don’t make changes to your production database at random. We believe that all changes should be tested in a safe test environment and migrated properly into production.
Our rates are competitive Contact us for availability.
Why hire us?
Server Tuning
SQL Tuning
Is the database working well for many processes but some specific processes are slow (i.e. Daily operations works fine, but nightly batch processing is slow). SQL Tuning will involve a detailed analysis of the process having problems and determining how the SQL or process should change to meet the required goal. We can help implement and test the recommendations that we make.
Oracle is the most complex database software sold today. Oracle’s tool for managing the database is the Enterprise Manager and if a company is willing to pay for the tuning pack, Enterprise Manager can show just about anyone recommendations for tuning the database. Are the recommendations correct for your system?
Performance tuners should NEVER rely on generic tools for tuning your database. Tuners should have a thorough understanding of all of Oracle’s supplied tools as well as their own scripts. This includes:
- Custom Scripts -
This is the most important tool that any DBA or tuner should have. All of the years of experience that a tuner has is in the the custom scripts that they use on a regular basis. For this reason alone, you need an experienced performance tuner working on your system. - Explain Plan -
This is used by a tuner to see how Oracle will retrieve your data. Experienced tuners understand the access paths and how to modify a statement to retrieve data efficiently. A tuner should know how to use hints, when to create indexes, and create SQL Profiles or Stored Outlines to modify an execution plan. - Traces and TKPROF-
By generating a SQL trace and using TKPROF, it is very easy to find which SQL statement is running the longest for any complex process. At a minimum, tuners should understand 10046 and 10053 traces. - AWR/Statspack -
These reports show the general performance of the entire system. The different sections describe specific areas of the database performance and can show us everything from the speed of the disks to top SQL to which datafiles are busiest.
- SQL Profiler -
This tool allows the tuner to look at the impact of the SQL statements within PL/SQL code to see which statements are running the longest and what is impacting performance.
Performance tuning is the art of analyzing the database and knowing how to make the right change to improve performance. Performance Tuning starts with identifying the problem, setting a realistic goal and tuning the database or SQL to reach that goal.
