yes, I should have said stored in UGA which is in PGA in dedicated server process, in shared pool when MTS is used