TO IMPLEMENT DAT BASE PERFORMANCE TUNING REPORTS WITH HELP OF TOOLS

Abstract

Performance tuning is the improvement of system performance. This is typically a computer application, but the same methods can be applied to economic markets, bureaucracies or other complex systems. The motivation for such activity is called a performance problem, which can be real or anticipated. Most systems will respond to increased load with some degree of decreasing performance. A system's ability to accept higher load is called scalability, and modifying a system to handle a higher load is synonymous to performance tuning. AWR periodically gathers and stores system activity and workload data which is then analyzed by Automatic Database Diagnostic Monitor (ADDM). Every layer of Oracle is equipped with instrumentation that gathers information on workload which will then be used to make self-managing decisions. AWR is the place where this data is stored. AWR looks periodically at the system performance (by default every 60 minutes) and stores the information found (by default up t...