Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL memory usage?

RE: PL/SQL memory usage?

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 2 Aug 2005 13:49:33 -0500
Message-ID: <1F989681BA05FA4CAD9FA849ED8520579B4BF4@pscdalpexch01.perotsystems.net>


Monitor "session pga memory" in v$sesstat.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Leandro Guimaraes Faria C. Dutra
Sent: Tuesday, August 02, 2005 1:40 PM
To: ryan_gaffuri_at_comcast.net
Cc: Oracle-L_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: PL/SQL memory usage?

oracle-l-bounce_at_freelists.org gravou em 2005-08-02 15:37:50:

> memory allocation for pl/sql tables is unbounced. you can make your
> arrays so big that you use up so much memory on a server that you
> cannot make a SSH connection to the server and cannot connect to
sqlplus.

        OK, but is this memory used from the SGA, PGA, or does Oracle allocate something outside of these memory areas?

> i dont think storing all this in an array would make that much of a
> difference. The best way to i mprove performance of this kind of
> thing is to look at the algorithm and see if there is a better way
> to do it and to see if you can parallelize your steps. For example,
> can you open up some oracle jobs and run 3 things at the same time.

        Agreed... I just don't know if the programmers will get that. They
are Clipper guys commissioned to do an Oracle system, not a good prospect
at all.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 02 2005 - 13:52:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US