Operating system level tuning

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.

- Interpreting the counter data to locate system-level performance bottlenecks and opportunities for improving the way your application interacts with the system.
Explain rule-based optimizer and cost-based optimizer
Oracle decides how to retrieve the necessary data whenever a valid SQL statement is processed......
Oracle database objects
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
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.......
Post your comment