My Oracle Support Banner

How to use OS Commands to Diagnose Database Performance Issues? (Doc ID 1401716.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

The purpose of this document is to provide a few OS commands for UNIX operating systems to gather information about Physical Memory (RAM), swap memory,CPU usage and idle percentage--whether lots of processes are in the process run queue and whether too much paging and swapping going on in the server or not so that we can use the information along with Statspack and AWR report to help diagnose the Database Performance issues.

Sometimes, the information gathered using these commands will be helpful in finding the most OS resource consuming database or non-database processes and will help in identifying the processes to further investigations about why the processes are consuming so much resources and whether the corresponding query or application needs to be tuned.


This document can be used by anyone with moderate expertise to run UNIX OS commands in various operating systems like Solaris, HP-UX, AIX, TRU64, Linux, etc. The commands will help us collect OS related information to verify whether overuse of any of the OS resources can be affecting the database performance or not. This document does not deal with OS Kernel tuning.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 HP-UX 11.0:
 Linux [RedHat 7.1 and RedHat AS 2.1]:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.