I have been reading the ORACLE fundamentals 1 book and I am just not
being able to find enough information on this issue. I'd like to know
if both the SQL areas of PGA and Library cache from SGA are capable of
storing binding information and parse trees.
if a pl/sql procedure is issued, in a dedicated server configuration
where would the bind variable values be stored and where would the
parse information be stored?
Also, if the same procedure is issued, but on a shared server
configuration where would the bind information and parse information be
stored (what part of the SGA)?
Received on Thu Dec 08 2005 - 11:28:05 CST
