Re: Exporting and Importing SQL Statement Cache

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 :)

HTH, Steve Received on Wed Nov 26 2008 - 10:04:15 CST