Matt wrote:
> Does anyone know whether issuing an 'alter session..' command will
> invalidate cursors.
>
> i.e. if I run
>
> SQL> alter session set optimizer_index_caching=90;
>
> Will I need to flush the shared pool to see the effects of running the
> same statement with this new optimizer parameter..?
>
> (8.1.7.4.1 Windows and 9.2.0.4 Windows)
This will not invalidate cursors. You can flush shared_pool if you want.
But if you are testing a query to make sure if the optimizer uses a
different execution plan, then you can change something in the query to
force re-parsing the query.
Received on Sat Nov 06 2004 - 12:20:03 CST
