My Oracle Support Banner

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

Last updated on JULY 26, 2019

Applies to:

Oracle Database Products > Oracle Database Suite > Oracle Database
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. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.