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

Last updated on SEPTEMBER 04, 2024

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

Give some background for what causes high memory usage
Describe a simple way to identify high memory usage
Describe a simple way to identify the process or processes causing high memory usage
Describe how to get more detailed information if the process is an Oracle process

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

Questions and Answers

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.