Re: Reduce latch row cache objects with event 10089

  • From: Stefan Koehler <contact@xxxxxxxx>
  • To: Petr.Novak@xxxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Mar 2015 16:29:38 +0100 (CET)

Hi Petr,
yes, i fiddled about event 10089 in one specific application scenario (not in 
general). However as Jonathan said it should be the last option. Any
particular questions about it?

The following slides are a good starting point for showing the impact on the 
CBO: https://williamtang2012.files.wordpress.com/2013/04/event-10089.pdf
 
Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK

> Petr Novak <Petr.Novak@xxxxxxxxxxxx> hat am 17. März 2015 um 15:16 
> geschrieben:
>
>
> Hallo,
>
> according Metalink Note 1485410.1
> event 10089 could be set. Does anybody has experience with it ?
>
> Best Regards,
> Petr--
--
//www.freelists.org/webpage/oracle-l


Other related posts: