Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Shared pool
Hello
Two questions(9iR2):
what become the SQL in the shared pool when user
logoff, does it stay in and
can be reused by other session, or does it is
flushed ?
In statspack report, the elapsed time about SQL
request seem to be very short
regarding the number of execution, is this data
reliable ? I get 200 000 +
number of execution for less than 12 sec elapsed
time ?
Thank yu Received on Wed Feb 01 2006 - 14:53:04 CST