This content has been marked as final. Show 3 replies
No Issues with code,
The ORA-04030 error is telling you that an Oracle process has requested memory from the operating system but the OS does not have any memory to give. Possible solutions include:
1. Adding more physical memory (RAM) to the database server. 2. Increasing the temp space on your database server and/or verifying that your temp disk is not full. 3. Decreasing your database footprint so that it uses less memory. You may want to decrease the SHARED_POOL_SIZE and DB_CACHE_SIZE initialization parameters.
There is something that I don't understand.
Why can I execute once this procedure and not repeatedly ? At the end of the procedure should I unallocated variables, free some memory ?
I'm alone on the database and the server.
so the server capacity does not change
Edited by: Zabo on Feb 26, 2010 5:09 AM