9i serially_reusable packages; 'call to the server is done'

From: ken quirici <ken.quirici_at_excite.com>
Date: 16 Nov 2006 10:07:48 -0800
Message-ID: <1163700467.930436.12760@k70g2000cwa.googlegroups.com>

Hi,

According to the 9i docs, the global memory for a serially_reusable package is stored in SGA and the space is returned when the call to the server is done.

While this server call is executing, and 'using' the global memory of the package, can any other package access this global memory - e.g., to call one of its functions to alter some variable in the package's global memory?

If yes, does Oracle allocate the package global memory in the 2nd caller's UGA?

Also, what does 'call to the server is done' mean - when the session is over? Does that session lock other sessions out of the package?

Thanks.

Ken Received on Thu Nov 16 2006 - 12:07:48 CST