Well, that might be useful by itself to - avoid shared pool fragmentation - prevent other ready to fire inconsistencies - remind the boss of DBA importance of which the later is the only acceptable reason :-) BTW, one of Oracle sale reps told me that they have a new "service". Those customers who can not afford Premium Support, can pay some extra for SR processing speedup. Does anybody else ever heard of such a "service"? --Andrey On Wed, January 10, 2007 03:49, Mladen Gogala wrote: > I believe that the advice will be to restart the instance, > which is great, especially if you're running a 24x7 database. -- //www.freelists.org/webpage/oracle-l