RE: Reduce latch row cache objects with event 10089

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 18 Mar 2015 11:32:30 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D928276AB5_at_EXMBX01.thus.corp>

And some indexes may have been used when there was a better option.

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: Timur Akhmadeev [timur.akhmadeev_at_gmail.com] Sent: 18 March 2015 11:16
To: Petr.Novak_at_trivadis.com
Cc: Jonathan Lewis; oracle-l_at_freelists.org Subject: Re: Reduce latch row cache objects with event 10089

On Wed, Mar 18, 2015 at 9:08 AM, Petr Novak <Petr.Novak_at_trivadis.com<mailto:Petr.Novak_at_trivadis.com>> wrote: I check continually index usage in shared pool and AWR, there are only 1-2 index candidates for elimination.

Do not need to look into AWR for that. Start with listing indexes & indexed columns instead, just looking at what is indexed + at avg_data_blocks_per_key. Very often people introduce redundant & unnecessary/inefficient indexes which could be logically eliminated.

--

Regards
Timur Akhmadeev
--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 18 2015 - 12:32:30 CET