Re: v$object_usage: anyone have bad experience with it?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 5 Feb 2005 16:03:50 -0000
Message-ID: <002f01c50b9c$48824db0$6702a8c0@Primary>

v$segment_statistics will only give you a clue about your index use, after all, the index will have to be traversed for every insert, update, delete and RI check. This means you will see logical I/Os, even when no execution plans take advantage of the index.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated Jan 21st 2005

Original Message ----- From: "Tanel Põder" <tanel.poder.003_at_mail.ee> To: "ORACLE-L" <oracle-l_at_freelists.org> Sent: Saturday, February 05, 2005 3:39 PM Subject: Re: v$object_usage: anyone have bad experience with it?

Hi,

You might also want to check from v$segment_statistics whether anyone is actually using your indes (logical reads, segment scans) if your statistics level allows segment-level statistics gathering.

--

http://www.freelists.org/webpage/oracle-l Received on Sat Feb 05 2005 - 11:06:31 CST