Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared pool
On Wed, 1 Feb 2006 21:53:04 +0100, "Sylvestre" <Sylvestre_at_world.com>
wrote:
>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 ?
>
it stays and can be reused.
>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
>
>
The data is reliable. If you can proof otherwise, it would be nice to
know for everyone of course.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Feb 01 2006 - 15:47:00 CST