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.

--
Leandro Guimarães Faria Corcete DUTRA
Administrador de Bases de Dados      +55 (11) 4390 5383
Toyota do Brasil Ltda              ldutra_at_toyota.com.br
São Bernardo do Campo, SP                        BRASIL


This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference.
--
http://www.freelists.org/webpage/oracle-l