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? 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> If there is a large pool configured MTS will ONLY
try to use this pool</tt></font>
<br><font size=2><tt> for a sessions UGA. When a new session is started a
small amount of memory </tt></font>
<br><font size=2><tt> (known as the fixed UGA) is allocated in the shared
pool and the rest of</tt></font>
<br><font size=2><tt> the session memory (UGA) is taken from the large
pool. If there is </tt></font>
<br><font size=2><tt> insufficient space left in the large pool an ORA
-4031 error will be </tt></font>
<br><font size=2><tt> returned similar to this:</tt></font>
<br>
<br><font size=2><tt> ORA-04031 (See ORA-04031.ora-code.com): unable to allocate 636 bytes of
shared memory </tt></font>
<br><font size=2><tt> (
"large pool","EMPSCOTT","session heap","
;define var info")</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? I believe this is an error in
the note? 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) 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 & 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>
|
|
