Oracle database tuning questions and answers

Oracle includes many performance tuning enhancements like: Automatic Performance Diagnostic and Tuning Features......
In Proactive Tuning, the application designers can then determine which combination of system resources.....
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 decides how to retrieve the necessary data whenever a valid SQL statement is processed......
Oracle database objects - Tables, indexes, views, synonyms, sequences, partitions, clusters, stored procedure and packages, user-defined data types, table spaces, constraints......
Oracle correlated sub-queries - A query which uses values from the outer query is called as a correlated sub query. The subquery is executed once and uses the results for all the evaluations in the outer query.......
Tuning disk and network I/O subsystem to optimize the I/O time, network packet size and dispatching frequency is called the server kernel optimization.....
What is a dynamic performance view in Oracle?...