Is there a setting which will flush the shared pool?
Please go to Help | Index | and type "flush shared pool".
There you will find all the information needed about this.
Caution: Using this option instructs Oracle to clear out all of the shared pool and could impact the performance of your production server while data buffers and other memory buffers are re-populated. The effect of this command depends upon the version of Oracle you are running.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center