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

Home -> Community -> Mailing Lists -> Oracle-L -> Resetting execution plan

Resetting execution plan

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 30 Nov 2006 14:30:35 +0100
Message-ID: <6e9345580611300530i25834123u84420dd2c70a368d@mail.gmail.com> 





Hi



Anyone know a trick which can invalidate a cursor execution plan?



I know if you run any DDL against a tabble we can invalidate the execution
plans related to the table but that affects many cursors, I was wondering if
there is any trick to reset a single cursor execution plan?



TIA


LSC



--
http://www.freelists.org/webpage/oracle-l


Received on Thu Nov 30 2006 - 07:30:35 CST












Original text of this message













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