RE: Reduce latch row cache objects with event 10089
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "Petr.Novak@xxxxxxxxxxxx" <Petr.Novak@xxxxxxxxxxxx>
- Date: Wed, 18 Mar 2015 11:32:30 +0000
And some indexes may have been used when there was a better option.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________________
From: Timur Akhmadeev [timur.akhmadeev@xxxxxxxxx]
Sent: 18 March 2015 11:16
To: Petr.Novak@xxxxxxxxxxxx
Cc: Jonathan Lewis; oracle-l@xxxxxxxxxxxxx
Subject: Re: Reduce latch row cache objects with event 10089
On Wed, Mar 18, 2015 at 9:08 AM, Petr Novak
<Petr.Novak@xxxxxxxxxxxx<mailto:Petr.Novak@xxxxxxxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
