My Oracle Support Banner

FAQ: How can I Investigate Memory Usage on my Unix/Linux Server (Doc ID 1447481.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Database Products > Oracle Database Suite > Oracle Database
Information in this document applies to any platform.

Purpose

This article is intended to

Questions and Answers

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
Purpose
Questions and Answers
 Background
 How can I confirm high memory usage is occurring?
 How can I identify the process(es) causing high memory usage?
 Shared memory - SGA
 Private memory - PGA
 How can I see which processes are using memory, from an O/S point of view?
 How can I see which processes are using memory, from an Oracle point of view?
 How can I reconcile the O/S memory users to the Oracle Memory users?
 Are the highest O/S memory consumers also the highest PGA consumers?
 Is a single Oracle process responsible for the majority of the memory allocation?
 Are there multiple Oracle processes consuming all memory?
 Are there a large number of INACTIVE jobs in the PGA report?
 What about PL/SQL?

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