Here is Oracle Performance tuning Glossary. It is quite a complex and interesting topic. Oracle performance tuning needs thorough analysis and knowledge of all the aspects of Oracle database Autotrace Autotrace is a beautiful tool provided by Oracle for getting the explain plan and execution statistics. You need to know the query and its bind […]
sql performance tuning
How to do sql tuning in Oracle
Introduction to Sql Tuning Sql statement are written to retrieve /fetch data from the database. We want our sql statement to running fast(sql tuning) and providing the results in secs. A poorly design sql could slow down the entire database operation and bring the entire operation to halt. It is much harder to write efficient […]
