Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Index_stats

Index_stats

From: Klavers, Richard <R.Klavers_at_arbeidsbureau.nl>
Date: Mon, 1 May 2000 16:31:08 +0200
Message-Id: <10484.104546@fatcity.com> 





Hi list,



I am analyzing my indexes (analyze index ... validate structure) to find the
one's with a low percentage of pct_used. 
However, when i am done analyzing, i only see the last analyzed index in the
table sys.index_stats.


This is the table with the column pct_used that i need.
Is there another table where i can find all the indexes? Or is there another
way to accomplish this task?


Thanx in advance, 



kind regards, Richard Klavers.
Received on Mon May 01 2000 - 09:31:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US