That's the only place to see the information. You will have to read whatever
information you need from index_stats and save it some where else after each
index is analyzed.
> -----Original Message-----
> From: Klavers, Richard [SMTP:R.Klavers_at_arbeidsbureau.nl]
> Sent: Monday, May 01, 2000 10:37 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Index_stats
>
> 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.
>
>
> --
> Author: Klavers, Richard
> INET: R.Klavers_at_arbeidsbureau.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 01 2000 - 10:43:05 CDT
