Re: Exporting and Importing SQL Statement Cache
Date: Wed, 26 Nov 2008 08:04:15 -0800 (PST)
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?
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