Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shared pool

Re: Shared pool

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 01 Feb 2006 22:47:00 +0100
Message-ID: <bva2u1hr8u0kq5gv1aacsdvpuhj3unetq2@4ax.com>


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 DBA
Received on Wed Feb 01 2006 - 15:47:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US