Re: Memory Usage in Oracle

jeffchirco_at_gmail.com wrote:
> I don't understand the question about suing PL/SQL to process.

You can pass in sql or you can have your processes compiled in packages procedures and functions. If your database has compiled pl/sql procedures that create cursors, it can effectively eat up all your memory if you have no programmatic limit on the cursor.

psuedo code example:
call procedure GetRecords
create cursor as select * from 1 terabyte table; Work with cursor
End procedure

All available os memory will be allocated to the offending process, system will swap, and die. It will die on the cursor create and never get to the work. Received on Thu Jan 11 2007 - 16:03:04 CST