Re: Reduce latch row cache objects with event 10089
From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 17 Mar 2015 16:29:38 +0100 (CET)
Message-ID: <1091613312.19759.1426606178814.JavaMail.open-xchange_at_app04.ox.hosteurope.de>
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?
Date: Tue, 17 Mar 2015 16:29:38 +0100 (CET)
Message-ID: <1091613312.19759.1426606178814.JavaMail.open-xchange_at_app04.ox.hosteurope.de>
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: _at_OracleSK
> Petr Novak <Petr.Novak_at_trivadis.com> 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--
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 17 2015 - 16:29:38 CET