Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index_stats
Hi Richard,
Have a look at the sparse_indexes.sql script on my web site. It calculates the percentage used directly from the data dictionary statistics.
Regards,
Steve Adams
http://www.ixora.com.au/ http://www.oreilly.com/catalog/orinternals/ http://www.christianity.net.au/ -----Original Message----- From: Klavers, Richard [SMTP:R.Klavers_at_arbeidsbureau.nl] Sent: Tuesday, May 02, 2000 1: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 Wed May 03 2000 - 14:04:00 CDT
![]() |
![]() |