Abstract
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 database (and corresponding process) is consuming the most operating system resources. This approach is invaluable when one database application is consuming resources to the point of causing other databases on the box to perform poorly.
-
You need to verify if the database server is adequately sized for current application workload in terms of CPU, memory, disk I/O, and network bandwidth.
-
An analysis is needed to determine at what point the server will not be able to handle larger (future) workloads.
-
You’ve used database tools to identify system bottlenecks and want to double-check the analysis via operating system tools.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2011 Sam R. Alapati, Darl Kuhn, and Bill Padfield
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2011). Analyzing Operating System Performance. In: Oracle Database 11g Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3663-4_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3663-4_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3662-7
Online ISBN: 978-1-4302-3663-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books