Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Issy les Moulineaux, France
    Posts
    24

    Unanswered: Freeing memory PLSQL table

    Hi all,

    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 ?

    Thanks.

    Eric.

    ( I use Oracle 8.1.7 )

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Try assigning an empty table to your table. This I believe will free up the memory unlike delete.

    Alan

  3. #3
    Join Date
    Jan 2004
    Location
    Issy les Moulineaux, France
    Posts
    24
    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.

    Eric.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •