Re: Re: Rollback waiting on 'cache buffer chains' latch

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.

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