| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-4030 pga memory allocation running wild
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3CA3B.18464611"
------_=_NextPart_001_01C3CA3B.18464611
Content-Type: text/plain
Are you using a big sort area size? any high degree of parallelism?
This could be some kind of memory leak!
Waleed
-----Original Message-----
Sent: Wednesday, December 24, 2003 7:14 AM
To: Multiple recipients of list ORACLE-L
Problem seems to be that both workarea_size_policy=manual and Pga_aggregate_target=0 must be in place in order to have effect. I couldn't change pga_aggregate_target online, so I moved to a testbox Where I could rebout and then the program was successful.
This kind of worries me that I have to change the database behaviour for just one program. I studies the docs a bit more and now it's on manual I have to reconsider all kind of *area_size again. Anyone seen this behaviour Before and are there any special considerations to make now, for example Sort_area_size smaller?
startvalues v$pgastat with workarea_size_policy manual and pga_aggregate_target=0
NAME VALUEUNIT
---------------------------------------------------------------- ---------- ------------ aggregate PGA target parameter 0 bytes aggregate PGA auto target 0 bytes global memory bound 0 bytes total PGA inuse 48437248 bytes total PGA allocated 1201760256 bytes maximum PGA allocated 1206069248 bytes total freeable PGA memory 0 bytes PGA memory freed back to OS 0 bytes total PGA used for auto workareas 0 bytes maximum PGA used for auto workareas 0 bytes total PGA used for manual workareas 0bytes
NAME VALUEUNIT
---------------------------------------------------------------- ---------- ------------ maximum PGA used for manual workareas 0 bytes over allocation count 0 bytes processed 0 bytes extra bytes read/written 0 bytes cache hit percentage 0percent
NAME VALUEUNIT
---------------------------------------------------------------- ---------- ------------ aggregate PGA target parameter 0 bytes aggregate PGA auto target 0 bytes global memory bound 0 bytes total PGA inuse 1105702912 bytes total PGA allocated 1194745856 bytes maximum PGA allocated 1206069248 bytes total freeable PGA memory 0 bytes PGA memory freed back to OS 0 bytes total PGA used for auto workareas 0 bytes maximum PGA used for auto workareas 0 bytes total PGA used for manual workareas 0bytes
NAME VALUEUNIT
---------------------------------------------------------------- ---------- ------------ maximum PGA used for manual workareas 0 bytes over allocation count 0 bytes processed 0 bytes extra bytes read/written 0 bytes cache hit percentage 0percent
16 rows selected.
12:47:56 SQL> /
16 rows selected.
As you can see in total pga inuse increasing this program consumes about 1Gb. I have the source available and this program is definitely running without global variables. It's a package with functions and procedures declaring cursors locally inside the functions or procedures. Could this amount of pga consuming be due to the program or might oracle have some problems here (also because of the error below instantiation space leak)?
Is there any way to run these kind of programs in a protected way that they may even go to disk if they need more memory than available?
Regards,
Jeroen
-----Oorspronkelijk bericht-----
Van: Jeroen van Sluisdam
Verzonden: Tuesday, December 23, 2003 23:19
Aan: 'ORACLE-L_at_fatcity.com'
Onderwerp: RE: ora-4030 pga memory allocation running wild
Hi,
I'm using oracle 9.2.0.4. I put it off tonight with the statement You mentioned and unfortunately no success.
Maybe interesting to know that I started without the event 4030 set
And I get the following ora-600 in my alert file:
Tue Dec 23 16:46:42 2003
Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_15251.trc:
ORA-00600: internal error code, arguments: [17271], [instantiation space
leak], [], [], [], [], [],
This one is reproducible without the event set and a pga_aggregate_target
set either 250Mb or 160Mb
With the event set I got the following error
Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_10264.trc:
ORA-04030: out of process memory when trying to allocate 2464 bytes (cursor
work he,rworalo : rwordops)
Tue Dec 23 14:24:40 2003
Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_10249.trc:
ORA-00600: internal error code, arguments: [17271], [instantiation space
leak], [], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 32 bytes
(callheap,allocator state)
This second tracefile lead me to the sql-statement which explained with a
very nice result
When I issued the statement to set off auto handling I did not get any such error in my alert file but my batch returned again after an hour With
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 56 bytes
(callheap,PESBLT space)
Could a UX kernel parameter be of any influence here, like max data segment? Could it help to increase this to say 3Gb. Note that we have 4Gb physical memory and 4Gb swap configured.
I used to run this in an oracle 7 enviroment on hpux 10.20 and now we moved To 64bit hpux11.11. I can imagine oracle is using more memory here than compared to oracle 7 with the same program such that in the old environment we might stayed below 2Gb and now we are exceeding this.
For what it might be worth, this batch is quite big. Sofar this seems to be the only program having memory problems. I have put back workare_size_policy=auto back to be on the safe default side.
I hope you can give some more leads because this is quite confusing And causing me headaches because it is causing troubles in my production environment. By the way we tested the migration ofcourse but this batch was not included in the test.
Regards,
Jeroen
-----Oorspronkelijk bericht-----
Van: Jared Still [mailto:jkstill_at_cybcon.com]
Verzonden: dinsdag 23 december 2003 18:34
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: ora-4030 pga memory allocation running wild
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set workarea_size_policy=manual;
Jared
On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote:
> Hi,
>
> I have an ora-4030 problem related to pga memory allocation, at least I
have
> concluded sofar
> This program is batch written in pl/sql and after an hour or so it
crashes.
> PGA allocated is slowly exceeding
> 2Gb and when I monitor with top I see the process size rising uptill 2 Gb
> somewhere.
> Last week we migrated from on oracle 7 environment where this program ran
> smoothly for years.
> At the same time we migrated the OS also and started with new machines.
The
> ux kernel parameter
> for max data segment size is 2Gb.
>
> I had an oracle consultant here for migration and he advised to put
> pga_aggegrate_target on 250M. Box has
> 4Gb, shared_pool_size is 250Mb, SGA is almost 800Mb
>
> I issued a tar and Oracle advised me to remove pga_aggegrate_target from
the
> init_file, but because this is production I cannot restart that
> easily (online changes are allowed ony from min. value 10M)
> I also tested this program with event :
> alter session set events '4030 trace name errorstack level 3'; I found the
> so called SQL-statement that might be causing this
> but explaining this plan gave me an even better plan than on the oracle 7
> environment Oracle support still has to get back to me with
> latest things.
>
> This program is clearly running wild on memory. Based on the docs on
> metalink I lowered the pga_aggegrate_target to 160M
> now and I'm testing this right now. Is there any way to protect your
system
> from memory consumption like this case. Are there any
> other parameters to consider?
>
> Details: oracle 9.2.0.4 HPUX 11.11, 4Gb phys memory
>
> Thanks in advance,
>
> Jeroen
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: jkstill_at_cybcon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C3CA3B.18464611 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20 "urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20 "urn:schemas-microsoft-com:office:smarttags"><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META content=3DWord.Document name=3DProgId> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <META content=3D"Microsoft Word 10" name=3DOriginator><LINK=20 href=3D"cid:filelist.xml_at_01C3CA1F.D6C3F7F0" = rel=3DFile-List><o:SmartTagType=20 name=3D"time"=20 namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag= Type><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:HyphenationZone>21</w:HyphenationZone> <w:EnvelopeVis/> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if !mso]> <STYLE>st1\:* { BEHAVIOR: url(#default#ieooui) } </STYLE> <![endif]--> <STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 70.85pt 69.6pt = 70.85pt 69.6pt; mso-header-margin: 35.4pt; mso-footer-margin: 35.4pt; = mso-paper-source: 0; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } A:visited { COLOR: purple; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline; text-underline: single } P.MsoPlainText { FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New = Roman" } LI.MsoPlainText { FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New = Roman" } DIV.MsoPlainText { FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New = Roman" } SPAN.SpellE { mso-style-name: ""; mso-spl-e: yes } SPAN.GramE { mso-style-name: ""; mso-gram-e: yes } DIV.Section1 { page: Section1 } </STYLE> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:Standaardtabel; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--></HEAD> <BODY lang=3DNL style=3D"tab-interval: 35.4pt" vLink=3Dpurple = link=3Dblue> <DIV><SPAN class=3D525383016-24122003><FONT color=3D#0000ff = size=3D2>Are you using a=20 big sort area size? any high degree of parallelism?</FONT></SPAN></DIV> <DIV><SPAN class=3D525383016-24122003><FONT color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D525383016-24122003><FONT color=3D#0000ff = size=3D2>This could be=20 some kind of memory leak!</FONT></SPAN></DIV> <DIV><SPAN class=3D525383016-24122003><FONT color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D525383016-24122003><FONT color=3D#0000ff=20 size=3D2>Waleed</FONT></SPAN></DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> Jeroen van = Sluisdam=20 [mailto:jeroen.van.sluisdam_at_vrijuit.nl]<BR><B>Sent:</B> Wednesday, = December=20 24, 2003 7:14 AM<BR><B>To:</B> Multiple recipients of list=20 ORACLE-L<BR><B>Subject:</B> RE: ora-4030 pga memory allocation = running=20 wild<BR><BR></FONT></DIV> <DIV class=3DSection1> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">Problem seems to = be that=20 <SPAN class=3DGramE>both<SPAN style=3D"mso-spacerun: yes"> = </SPAN><SPAN=20 class=3DSpellE>workarea</SPAN></SPAN><SPAN=20 class=3DSpellE>_size_policy</SPAN>=3Dmanual = and<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DSpellE><FONT face=3D"Courier = New" size=3D2><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US">Pga_aggregate_target</SPAN></FONT></SPAN><SPAN=20 lang=3DEN-US style=3D"mso-ansi-language: EN-US">=3D0 must be in place = in order to=20 have effect.<o:p></o:p></SPAN></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">I couldn't change = <SPAN=20 class=3DSpellE>pga_aggregate_target</SPAN> online, so I moved to a = <SPAN=20 class=3DSpellE>testbox</SPAN><o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">Where I could = <SPAN=20 class=3DSpellE>rebout</SPAN> and then the program was=20 successful.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">This kind of = worries me that=20 I have to change the database <SPAN class=3DSpellE>behaviour</SPAN> = for just one=20 program. I studies the docs a bit more and now it's on manual I have = to=20 reconsider all kind of *<SPAN class=3DSpellE>area_size</SPAN> again. = Anyone seen=20 this <SPAN = class=3DSpellE>behaviour</SPAN><o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">Before and are = there any=20 special considerations to <SPAN class=3DGramE>make<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>now</SPAN>, for=20 example<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DSpellE><SPAN = class=3DGramE><FONT=20 face=3D"Courier New" size=3D2><SPAN lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US">Sort_area_size</SPAN></FONT></SPAN></SPAN><SPAN=20 class=3DGramE><SPAN lang=3DEN-US style=3D"mso-ansi-language: EN-US">=20 smaller?</SPAN></SPAN><SPAN lang=3DEN-US=20 style=3D"mso-ansi-language: EN-US"><o:p></o:p></SPAN></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DSpellE><SPAN = class=3DGramE><FONT=20 face=3D"Courier New" size=3D2><SPAN lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US">startvalues</SPAN></FONT></SPAN></SPAN><SPAN=20 lang=3DEN-US style=3D"mso-ansi-language: EN-US"> <SPAN=20 class=3DSpellE>v$pgastat</SPAN> with <SPAN=20 class=3DSpellE>workarea_size_policy</SPAN> manual and <SPAN=20 class=3DSpellE>pga_aggregate_target</SPAN>=3D0<o:p></o:p></SPAN></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">NAME<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>VALUE UNIT<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">---------------------------------------------------------------- = ---------- ------------<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">aggregate</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> target parameter<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">aggregate</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> auto target<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp;=20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">global</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 memory bound<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> <SPAN = class=3DSpellE>inuse</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>48437248 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> allocated<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>1201760256 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">maximum</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> allocated<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>1206069248 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>freeable</SPAN> <SPAN class=3DSpellE>PGA</SPAN> = memory<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp;=20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DSpellE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">PGA</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 memory freed back to OS<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for auto <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">maximum</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for auto <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for manual <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">NAME<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; =20 </SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; </SPAN>VALUE=20 UNIT<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">---------------------------------------------------------------- = ---------- ------------<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">maximum</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for manual <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp;=20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">over</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 allocation count<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; =20 </SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; </SPAN>0<o:p></o:p>= </SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">bytes</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 processed<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">extra</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 bytes read/written<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">cache</SPAN></FONT>= </SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US"> hit=20 percentage<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 percent<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">NAME<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>VALUE UNIT<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">---------------------------------------------------------------- = ---------- ------------<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">aggregate</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> target parameter<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">aggregate</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> auto target<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp;=20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">global</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 memory bound<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> <SPAN = class=3DSpellE>inuse</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>1105702912 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> allocated<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>1194745856 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">maximum</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> allocated<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>1206069248 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>freeable</SPAN> <SPAN class=3DSpellE>PGA</SPAN> = memory<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp;=20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DSpellE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">PGA</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 memory freed back to OS<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for auto <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">maximum</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for auto <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">total</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for manual <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">NAME<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>VALUE UNIT<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">---------------------------------------------------------------- = ---------- ------------<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">maximum</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 <SPAN class=3DSpellE>PGA</SPAN> used for manual <SPAN=20 class=3DSpellE>workareas</SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp;=20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">over</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 allocation count<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">bytes</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 processed<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">extra</SPAN></FONT>= </SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 bytes read/written<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 bytes<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D1><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">cache</SPAN></FONT></SPAN><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US"> hit=20 percentage<SPAN=20 style=3D"mso-spacerun: = yes"> &= nbsp; &= nbsp; &= nbsp; &= nbsp; =20 </SPAN>0 percent<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">16 rows=20 selected.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><st1:time Minute=3D"47" Hour=3D"12"><FONT = face=3D"Courier New"=20 size=3D1><SPAN lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: = EN-US">12:47:56</SPAN></FONT></st1:time><FONT=20 size=3D1><SPAN lang=3DEN-US style=3D"FONT-SIZE: 8pt; = mso-ansi-language: EN-US">=20 SQL> /<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D1><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 8pt; mso-ansi-language: EN-US">16 rows=20 selecte</SPAN></FONT><SPAN lang=3DEN-US=20 style=3D"mso-ansi-language: EN-US">d.<o:p></o:p></SPAN></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">As you can see in = total=20 <SPAN class=3DSpellE><SPAN class=3DGramE>pga</SPAN></SPAN> <SPAN=20 class=3DSpellE>inuse</SPAN> increasing this program consumes about = 1Gb. I have=20 the source available and this program is definitely running without = global=20 variables. It's a package with functions and=20 procedures<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US">declaring</SPAN></FONT></SPAN><SPAN=20 lang=3DEN-US style=3D"mso-ansi-language: EN-US"> cursors locally = inside the=20 functions or procedures. Could this amount of <SPAN = class=3DSpellE><SPAN=20 class=3DGramE>pga</SPAN></SPAN> consuming be due to the program or = might oracle=20 have some problems here (also because of the error below = instantiation space=20 leak)?<o:p></o:p></SPAN></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US">Is there any way = to run=20 these <SPAN class=3DGramE>kind</SPAN> of programs in a protected way = that they=20 may even go to disk if they need more memory than=20 available?<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: EN-US"><o:p> </o:p><= /SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US">Regards,<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN = lang=3DEN-US=20 style=3D"FONT-SIZE: 10pt; mso-ansi-language: = EN-US">Jeroen<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">-----Oorspronkelijk</SPAN></FONT></SPAN>=20 bericht-----<o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><BR>Van: Jeroen van Sluisdam <BR>Verzonden: = Tuesday,=20 <SPAN class=3DGramE>December</SPAN> 23, 2003 23:19<BR>Aan:=20 'ORACLE-L_at_fatcity.com'<BR>Onderwerp: RE: ora-4030 pga memory = allocation=20 running wild<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Hi,<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">I'm using oracle 9.2.0.4. I put it off = tonight with=20 the statement<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">You mentioned and unfortunately no=20 success.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Maybe interesting to know that I started = without the=20 event 4030 set<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">And I get the following ora-600 in my alert = file:<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Tue Dec 23 16:46:42 = 2003<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Errors in file=20 = /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_15251.trc:<o:p></o:p><= /SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">ORA-00600: internal error code, arguments: = [17271],=20 [instantiation space leak], [], [], [], [], = [],<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">This one is reproducible without the event = set and a=20 pga_aggregate_target set either 250Mb or = 160Mb<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">With the event set I got the following=20 error<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Errors in file=20 = /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_10264.trc:<o:p></o:p><= /SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">ORA-04030: out of process memory when = trying to=20 allocate 2464 bytes (cursor work he<SPAN = class=3DGramE>,rworalo</SPAN> :=20 rwordops)<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Tue Dec 23 14:24:40 = 2003<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Errors in file=20 = /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_10249.trc:<o:p></o:p><= /SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">ORA-00600: internal error code, arguments: = [17271],=20 [instantiation space leak], [], [], [], [], [],=20 []<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">ORA-04030: out of process memory when = trying to=20 allocate 32 bytes (callheap<SPAN class=3DGramE>,allocator</SPAN>=20 state)<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">This second tracefile lead me to the = sql-statement=20 which explained with a very <SPAN class=3DGramE>nice</SPAN>=20 result<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">When I issued the statement to set off auto = handling I=20 did not get any such error in my alert file but my batch returned = again after=20 an hour <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">With<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">ERROR at line = 1:<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">ORA-04030: out of process memory when = trying to=20 allocate 56 bytes (callheap<SPAN class=3DGramE>,PESBLT</SPAN>=20 space)<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Could a UX kernel parameter be of any = influence here,=20 like <SPAN class=3DGramE>max</SPAN> data = segment?<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Could it help to increase this to say 3Gb. = Note that=20 we have 4Gb physical memory and 4Gb swap <SPAN=20 class=3DGramE>configured</SPAN>.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">I used to run this in an oracle 7 = enviroment on hpux=20 10.20 and now we moved<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">To 64bit hpux11.11. I can imagine oracle is = using more=20 memory here than compared to oracle 7 with the <SPAN = class=3DGramE>same</SPAN>=20 program such that in the old environment we might stayed below 2Gb = and now we=20 are exceeding this.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">For what it might be worth, this batch is = quite big.=20 Sofar this seems to be the only program having memory problems. I = have put=20 back workare_size_policy=3Dauto back to be on the <SPAN = class=3DGramE>safe</SPAN>=20 default side.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">I hope you can give some more leads because = this is=20 quite confusing <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">And causing me headaches because it is = causing=20 troubles in my production environment. By the way we tested the = migration=20 ofcourse but this batch was not included in the=20 test.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Regards,<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Jeroen<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">-----Oorspronkelijk</SPAN></FONT></SPAN>=20 bericht-----<o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Van: Jared Still [mailto<SPAN=20 class=3DGramE>:jkstill_at_cybcon.com</SPAN>] = <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Verzonden: dinsdag 23 december 2003=20 18:34<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Aan: Multiple recipients of list=20 ORACLE-L<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Onderwerp: Re: ora-4030 pga memory = allocation running=20 wild<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">I'm using auto pga allocation on 9.2.0.3 = without any=20 problem.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">You don't mention which=20 version.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">You can turn it off with 'alter system set=20 workarea_size_policy=3Dmanual;<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Jared<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">On Tue, 2003-12-23 at 07:24, Jeroen van = Sluisdam=20 wrote:<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> Hi,<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> I have an ora-4030 problem related to = pga memory=20 allocation, at least I have<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> concluded = sofar<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> This program is batch written in = pl/sql and after=20 an hour or so it crashes.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> PGA allocated is slowly=20 exceeding<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> 2Gb and when <SPAN = class=3DGramE>I<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN></SPAN>monitor with top I = see the=20 process size rising uptill 2 Gb<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN=20 class=3DGramE>somewhere</SPAN>.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> Last week we migrated from on oracle 7 = environment where this program ran<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> smoothly for = years.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> At the same <SPAN = class=3DGramE>time</SPAN> we=20 migrated the OS also and started with new machines.=20 The<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>ux</SPAN> kernel=20 parameter<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> for <SPAN class=3DGramE>max</SPAN> = data segment=20 size is 2Gb.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> I had an oracle consultant here for = migration and=20 he advised to put<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN = class=3DGramE>pga_aggegrate_target</SPAN> on=20 250M. Box has<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> 4Gb, shared_pool_size is 250Mb, SGA is = almost=20 800Mb<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> I issued a <SPAN = class=3DGramE>tar</SPAN> and=20 Oracle advised me to remove pga_aggegrate_target from=20 the<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>init_file</SPAN>, = but because=20 this is production I cannot restart that<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> easily (online changes are <SPAN=20 class=3DGramE>allowed</SPAN> ony from min. value 10M)=20 <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> I<SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN>also tested this program with <SPAN class=3DGramE>event=20 :</SPAN><o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>alter</SPAN> = session set events=20 '4030 trace name errorstack level 3'; I found = the<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>so</SPAN> called = SQL-statement=20 that might be causing this<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>but</SPAN> = explaining this plan=20 gave me an<SPAN style=3D"mso-spacerun: yes"> </SPAN>even better = plan than=20 on the oracle 7<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>environment</SPAN> = Oracle=20 support still has to get back to me with = <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>latest</SPAN>=20 things.<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> This program is clearly running wild = on memory.=20 Based on the docs on<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>metalink</SPAN> I = lowered the=20 pga_aggegrate_target to 160M<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> now and I'm testing this right now. Is = there any=20 way to protect your system<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> from memory consumption like this = case. Are there=20 any<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> <SPAN class=3DGramE>other</SPAN> = parameters to=20 consider?<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> Details: oracle 9.2.0.4 HPUX 11.11, = 4Gb phys=20 memory<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> Thanks in = advance,<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">><SPAN style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN></FONT></SPAN><o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">> Jeroen<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">-- <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Please see the official ORACLE-L FAQ:=20 http://www.orafaq.<SPAN = class=3DGramE>net</SPAN><o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">-- <o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Author: Jared = Still<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><SPAN style=3D"mso-spacerun: yes"> = </SPAN>INET:=20 jkstill_at_cybcon.com<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">Fat City Network Services<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>-- 858-538-5051 = http://www.<SPAN class=3DGramE>fatcity</SPAN>.com<o:p></o:p></SPAN></F= ONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">San Diego, <SPAN = class=3DGramE>California<SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN></SPAN>-- Mailing list and web hosting=20 services<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: = 10pt">------------------------------------------------------------------= ---<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">To REMOVE yourself from this mailing list, = send an=20 E-Mail message<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">to</SPAN></FONT></SPAN>: = ListGuru_at_fatcity.com (note=20 EXACT spelling of 'ListGuru') and in<o:p></o:p></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">the message BODY, include a line = containing: UNSUB=20 ORACLE-L<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><FONT face=3D"Courier New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">(or the name of mailing list you want to be = removed=20 <SPAN class=3DGramE>from).<SPAN style=3D"mso-spacerun: yes"> =20 </SPAN></SPAN>You may<o:p></o:p></SPAN></FONT></P> <P class=3DMsoPlainText><SPAN class=3DGramE><FONT face=3D"Courier = New" size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt">also</SPAN></FONT></SPAN> send the HELP = command for=20 other information (like=20 subscribing).<o:p></o:p></P></DIV></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C3CA3B.18464611-- ------=_NextPartTM-000-df15f59d-532b-46a4-8a04-5b9c442a21c7-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Dec 24 2003 - 10:34:24 CST
 |
 |