Oracle performance tuning (For Oracle DBAs)

Abstract

Timely access to information is one of the most important essentials of database management system. Delivering access to data in acceptable time is essential for effective decision making. Tuning inefficient SQL is one of the most significant elements of enhancing the performance of databases. With growing repositories and complexity of underlying information management systems, maintaining decent levels of execution and tuning has become a complicated job. DBMS providers acknowledge this tendency and development tools and features that simplify the process. DBAs and developers have to make use of these tools in the effort to provide their companies with stable and efficient organizations. Performance tuning functions differ from platform to platform. Oracle is the main DBMS provider in the universe and this study focuses on the tools provided in all outlets of their software. A thorough literature analysis is done in order to advance understanding of the functionality and assessment of each tool is executed likewise.