Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Large Pool and ORA-04031

Large Pool and ORA-04031

2005-12-16       - By Tracy Rahmlow


Is it possible to receive an ORA-04031 (See ORA-04031.ora-code.com)on a large_pool that is too small? I
did not think so until I stumbled across the following note (62140.1) on
Metalink:

MTS and the Large Pool
~~~~~~~~~~~~~~~~~~~~~~
 If there is a large pool configured MTS will ONLY try to use this pool
 for a sessions UGA. When a new session is started a small amount of
memory
 (known as the fixed UGA) is allocated in the shared pool and the rest of
 the session memory (UGA) is taken from the large pool.  If there is
 insufficient space left in the large pool an ORA-4031 (See ORA-4031.ora-code.com) error will be
 returned similar to this:

   ORA-04031 (See ORA-04031.ora-code.com): unable to allocate 636 bytes of shared memory
               ("large pool","EMPSCOTT","session heap","define var info")

If you run out of memory in the large_pool will Oracle begin to use the
shared_pool?  I believe this is an error in the note?  Do you agree?
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __

NOTE:
On Aug. 1 my e-mail address changed to tracy.rahmlow@(protected)  Please
begin using my new e-mail address starting Aug. 1. E-mails sent to my
current address, tracy.rahmlow@(protected), will reach me through Feb. 1,
2006
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __

Tracy Rahmlow | Lead Database Analyst
Information Systems
Ameriprise Auto & Home Insurance

AMEX Assurance Company
IDS Property Casualty Insurance Company
3500 Packerland Drive | De Pere, WI 54115-9070
Office: 920.330.5164 | Fax: 920.330.5350
tracy.rahmlow@(protected)
ameriprise.com/autohome
Ameriprise made the following
annotations on 12/16/05, 14:56:03
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
******************************************************************************

"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have
received this communication in error, please notify us by reply e-mail and
immediately and permanently delete this message and any attachments. Thank you.
"

******************************************************************************
==============================================================================


<br><font size=2 face="sans-serif">Is it possible to receive an ORA-04031 (See ORA-04031.ora-code.com)on a
large_pool that is too small? &nbsp;I did not think so until I stumbled across
the following note (62140.1) on Metalink: </font>
<br>
<br><font size=2><tt>MTS and the Large Pool</tt></font>
<br><font size=2><tt>~~~~~~~~~~~~~~~~~~~~~~</tt></font>
<br><font size=2><tt>&nbsp; If there is a large pool configured MTS will ONLY
try to use this pool</tt></font>
<br><font size=2><tt>&nbsp; for a sessions UGA. When a new session is started a
small amount of memory </tt></font>
<br><font size=2><tt>&nbsp; (known as the fixed UGA) is allocated in the shared
pool and the rest of</tt></font>
<br><font size=2><tt>&nbsp; the session memory (UGA) is taken from the large
pool. &nbsp;If there is </tt></font>
<br><font size=2><tt>&nbsp; insufficient space left in the large pool an ORA
-4031 error will be </tt></font>
<br><font size=2><tt>&nbsp; returned similar to this:</tt></font>
<br>
<br><font size=2><tt>&nbsp; &nbsp; ORA-04031 (See ORA-04031.ora-code.com): unable to allocate 636 bytes of
shared memory </tt></font>
<br><font size=2><tt>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (
&quot;large pool&quot;,&quot;EMPSCOTT&quot;,&quot;session heap&quot;,&quot
;define var info&quot;)</tt></font>
<br>
<br><font size=2 face="sans-serif">If you run out of memory in the large_pool
will Oracle begin to use the shared_pool? &nbsp;I believe this is an error in
the note? &nbsp;Do you agree?</font>
<br><font size=2 face="sans-serif">__ ____ ____ ____ ____ ____ ____ ____ ______
__ ___<br>
<br>
NOTE:<br>
On Aug. 1 my e-mail address changed to tracy.rahmlow@(protected) &nbsp;Please
begin using my new e-mail address starting Aug. 1. E-mails sent to my current
address, tracy.rahmlow@(protected), will reach me through Feb. 1, 2006<br>
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<br>
<br>
Tracy Rahmlow | Lead Database Analyst<br>
Information Systems<br>
Ameriprise Auto &amp; Home Insurance<br>
<br>
AMEX Assurance Company<br>
IDS Property Casualty Insurance Company<br>
3500 Packerland Drive | De Pere, WI 54115-9070<br>
Office: 920.330.5164 | Fax: 920.330.5350<br>
tracy.rahmlow@(protected)<br>
ameriprise.com/autohome</font>
<P>Ameriprise made the following<br>
annotations on 12/16/05, 14:56:03<br>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
<br>
******************************************************************************
<br>
<br>
"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have
received this communication in error, please notify us by reply e-mail and
immediately and permanently delete this message and any attachments. Thank you.
"<br>
<br>
******************************************************************************
<br>
==============================================================================
<br>
</P>