Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cursor Invalidation after "alter session" command...

Cursor Invalidation after "alter session" command...

From: Matt <mccmx_at_hotmail.com>
Date: 2 Nov 2004 06:14:26 -0800
Message-ID: <cfee5bcf.0411020614.31488294@posting.google.com> 





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)
Received on Tue Nov 02 2004 - 08:14:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US