Re: Reduce latch row cache objects with event 10089
From: Timur Akhmadeev <timur.akhmadeev_at_gmail.com>
Date: Wed, 18 Mar 2015 14:16:48 +0300
Message-ID: <CACGsLCJtNB_tFRYDitOWFJAuLLNkMawMpttqK=94c1qew7hQMw_at_mail.gmail.com>
On Wed, Mar 18, 2015 at 9:08 AM, Petr Novak <Petr.Novak_at_trivadis.com> wrote:
Date: Wed, 18 Mar 2015 14:16:48 +0300
Message-ID: <CACGsLCJtNB_tFRYDitOWFJAuLLNkMawMpttqK=94c1qew7hQMw_at_mail.gmail.com>
On Wed, Mar 18, 2015 at 9:08 AM, Petr Novak <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-lReceived on Wed Mar 18 2015 - 12:16:48 CET