Re: way to make sql statement stay on cache (SGA) logner?

From: Gus Spier <gus.spier_at_gmail.com>
Date: Sun, 31 Jan 2010 19:32:51 -0500
Message-ID: <6d3967611001311632ie9fb38bg67a518abd8d73945_at_mail.gmail.com>

A quick Google search for "oracle pin sql" will bring what you probably asking for.

r,

Gus

On Sun, Jan 31, 2010 at 6:17 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> We have ORACLE 10GR2 on UNIX server and some of SQL statements run much
> longer on first after that it only run few seconds. I know the reason first
> time SQL statements run need parse and other things, after that SQL
> statement on cache (SGA) and it will run shorter. But eventually SQL
> statement still will be age out from SGA.
>
> Does there has way to make SQL statement stay longer on cache (SGA)?
>
> Thanks.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jan 31 2010 - 18:32:51 CST