If your session needs to persist after you finish operations against Oracle OLAP multidimensional datatypes you can free up the PGA/UGA overhead by running the following commands in your session.

exec dbms_aw.shutdown;
exec dbms_session.free_unused_user_memory;