Re: Exporting and Importing SQL Statement Cache
Date: Wed, 26 Nov 2008 08:54:31 -0800 (PST)
On Nov 26, 4:04 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Nov 26, 10:50 am, Stevo <steven.robb..._at_gmail.com> 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 :)
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