Analyzing Operating System Performance

Solving database performance issues sometimes requires the use of operating system (OS) utilities. These tools often provide information that can help isolate database performance problems. Consider the following situations:

  • You’re running multiple databases and multiple applications on one server and want to use OS utilities to identify which process is consuming the most OS resources. This approach is invaluable when a process (that may or may not be related to a database) is consuming resources to the point of causing one or more of the databases on the box to perform poorly.
  • You need to verify ...

Get Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.