From: mlackey@illuminet.com (Michael Lackey) Newsgroups: comp.databases.oracle.server Subject: Re: Tuning - Indexes and Usage Date: 6 Jun 2001 11:44:42 -0700 Organization: http://groups.google.com/ Lines: 21 Message-ID: <600e9c26.0106061044.65110e5b@posting.google.com> References: NNTP-Posting-Host: 198.202.216.88 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 991853082 23950 127.0.0.1 (6 Jun 2001 18:44:42 GMT) X-Complaints-To: groups-support@google.com NNTP-Posting-Date: 6 Jun 2001 18:44:42 GMT A bit of a stretch, but if you could put an index in it's own datafile you could measure the Physical and/or logical reads. Not sure though if updates to the index cause any reads that are recorded. You could test this by creating an index that would never be used, add/update/delete rows and then look at the information in the v$filestat and v$datafile views. Then do queries that should read the index and see what happens. Could Try OEM performance manager and record this information for a duration when queries should cause reads on the index datafile. "Devdewboy" wrote in message news:... > Good Morning, > > Is there a script someone can provided me that will query the dynamic views > for index usages i.e. If an index has ever been utilized (this specifically) > and other useful info? > > Thanks, > > dewboy