My Oracle Support Banner

Troubleshooting and Diagnosing ORA-4031 Error [Video] (Doc ID 396940.1)

Last updated on MAY 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This article is intended to

 

Note:
If you would like to explore this topic further, please join the Community discussion 'Diagnosing and Resolving ORA-4031 errors' where you can ask questions, get help from others, and share your experiences with this specific article.

Common Bugs

Review <Note: 4031.1> for latest bug information searchable by release level.


NOTE:  References below to script names are canned scripts that can be found in <Note 430473.1> ORA-4031 Common Analysis/Diagnostic Scripts.   Look in the section of the article titled 'Software Requirements/Prerequisites'. You can download the zip file clicking on the 'Click here' link.    The scripts are updated over time, so please verify you have the latest versions of the scripts from time to time.

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
 Common Bugs
Questions and Answers
 How is memory allocated and deallocated in the SGA pools?
 What are Subpools?
 What is the Reserved Area?
 What are the pools in the SGA used for?
 What is an ORA-04031 Error?
 Is my Reserved Area sized properly?
 Is there a way to find a "right" size for the Shared Pool?
 How much free memory is available in my SGA?
 What is managed automatically through 10g ASMM and/or 11g AMM?
 How many Subpools will I have by default?
 How do I control the number of subpools used?
 Are all ORA-04031 errors reported in the alert log?
 How can we see a breakdown of the data in the "miscellaneous" structure in V$SGASTAT?
 What database parameters are relevant to ORA-04031 problems?
 What should we look at in an RDA to help diagnose a 4031 error?
 What is relevant in the default 4031 trace file?
 What is relevant in the Statspack/AWR report for a 4031 error?
 How can we determine if there are application issues causing the problem?
 Not Using Bind Variables
 Multiple child cursors
 High parse ratios
 Community discussion
References

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