RE: PL/SQL memory usage?
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <ldutra@xxxxxxxxxxxxx>, <ryan_gaffuri@xxxxxxxxxxx>
- Date: Tue, 2 Aug 2005 13:49:33 -0500
Monitor "session pga memory" in v$sesstat. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Leandro Guimaraes Faria C. Dutra Sent: Tuesday, August 02, 2005 1:40 PM To: ryan_gaffuri@xxxxxxxxxxx Cc: Oracle-L@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx Subject: Re: PL/SQL memory usage? oracle-l-bounce@xxxxxxxxxxxxx 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