Re: Exporting and Importing SQL Statement Cache

From: Stevo <>
Date: Wed, 26 Nov 2008 08:54:31 -0800 (PST)
Message-ID: <>

On Nov 26, 4:04 pm, Steve Howard <> wrote:
> On Nov 26, 10:50 am, Stevo <> wrote:
> > Hi All,
> > Does anyone know if it's possible to perform an export and import of
> > the SQL Statement Cache in Oracle 8i?
> > Thanks
> > Steve.
> Hi Steve,
> I'm not sure what you mean by export import of it, but you can always
> "select * from v$sql".  If you have statspack installed, you can also
> look at the stats$sql_summary table (and maybe others).
> To "import" it, start running the statements you pulled out above :)
> HTH,
> Steve

Thanks Steve,

I currently have oracle running on 2 servers and we only use one server in use at any one time. If we swap servers after a few days the new live server gets overloaded. If we swap servers after a short period of time the server has no trouble handling the traffic. I figured this is the sql statements being removed from the sql cache over time. So I'm trying to work out a way to preload the server with the sql statements before we swap sites. Is there a better way of doing this?

Steve. Received on Wed Nov 26 2008 - 10:54:31 CST

Original text of this message