Re: Why is UGA size so large?

Marcel D?rr apparently said,on my timestamp of 1/04/2005 6:43 PM:

> /* only if we remove the last row, the UGA size will shrink again

> */


>     globalTable.delete( globalTable.first);    

>     OutputUGASize( 'UGA after deleting whole table');

>     dbms_session.free_unused_user_memory;

>     OutputUGASize( 'UGA after DBMS_Session.free_unused_memory');

There you go: remove the last row and extend again. ;) That should solve your problem. I do recall this being documented somewhere in one of the old PL/SQL manuals. Only a total delete frees up the space. The other way used to be to keep an empty table around, same definition, and copy it to the large PL/SQL table. That shrunk the size, or so we were told.

Good piece of investigation you did!

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam