What is proactive tuning and reactive tuning?Tuning aims to increase and optimize Oracle’s throughput. In Proactive tuning, different strategies are developed for different kinds of processing. Here, the database is tuned by finding the optimal hardware selection, capacity planning and settings to increase throughput. It is called proactive as the administrator proactively devises strategies for the architecture. Reactive tuning involves performance tuning and troubleshooting within boundaries of existing architecture.
What is proactive tuning and reactive tuning? In Proactive Tuning, the application designers can then determine which combination of system resources and available Oracle features best meet the needs during design and development.
In reactive tuning the bottom up approach is used to find and fix the bottlenecks. The goal is to make Oracle run faster.
Operating system level tuning
System-level tuning involves the following steps: Monitoring the operating system counters using a tool such as top, gtop, and GKrellM or the VTune analyzer’s counter monitor data collector for applications running on Windows.....
Oracle database objects
Oracle database objects - Tables, indexes, views, synonyms, sequences, partitions, clusters, stored procedure and packages, user-defined data types, table spaces, constraints......