Re: v$object_usage: anyone have bad experience with it?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <tanel.poder.003@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 5 Feb 2005 16:03:50 -0000
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@xxxxxxx>
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
