Re: Exporting and Importing SQL Statement Cache

From: Steve Howard <>
Date: Wed, 26 Nov 2008 08:04:15 -0800 (PST)
Message-ID: <>

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 Received on Wed Nov 26 2008 - 10:04:15 CST

Original text of this message