var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Freeing memory PLSQL table
I use a PLSQL table TEMP in a package an I want to make a procedure to empty this table and free memory used by the table.
Seems TEMP.DELETE does not free memory. I don't find anything in PL/SQL book.
Any ideas ?
( I use Oracle 8.1.7 )
Try assigning an empty table to your table. This I believe will free up the memory unlike delete.
Thanks for your reply Alan.
I was wrong. Both delete and assigning an empty table work fine.
But memory is not freed, only mark reusable. So I didn't see any decrease of PGA memory.
I must call DBMS_SESSION.FREE_UNUSED_USER_MEMORY to free memory, but it's not necessary. Filling the table after a delete won't increase PGA memory.