Xref: alice comp.databases.oracle.server:75493 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.wirehub.nl!not-for-mail From: "akolk - gelrevision.nl" Newsgroups: comp.databases.oracle.server Subject: Re: Unused indexes Date: Thu, 25 Nov 1999 10:24:41 +0100 Organization: Wirehub! Internet Lines: 28 Message-ID: <383D0059.D3DE53BF@gelrevision.nl> References: <80o331$cjl$1@pamir.k2.net> <382FFACD.13AB@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: thor.wirehub.nl 943518516 66609 195.86.58.244 (25 Nov 1999 08:28:36 GMT) X-Complaints-To: abuse@wirehub.net NNTP-Posting-Date: 25 Nov 1999 08:28:36 GMT X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.9 i686) X-Accept-Language: en, pt-BR, pt This only works for Oracle8 ! Not 7.3 Anjo. Connor McDonald wrote: > Boris Oblak wrote: > > > > Hi, > > > > How can i found unused or inefficient indexes on Oracle 7.3 or Oracle8? > > > > Thanks, > > Boris > > > > e-mail:boris.oblak@k2.net > > You could always scan x$bh at period intervals, join to OBJ$ for TYPE#=1 > which will tell you what indexes are in the buffer cache... > > -- > =========================================== > Connor McDonald > "These views mine, no-one elses etc etc" > connor_mcdonald@yahoo.com > > "Some days you're the pigeon, and some days you're the statue."