RE: Feedback on query for monitoring index usage in 9i

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Thu, 29 Jul 2004 12:28:08 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93BC3@qtiexch2.qgraph.com>

The part that's missing from that one is the ability to see all indexes = in order to determine if an index exists that isn't monitored (without = another join).

Thanks for the feedback!
Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_quadtechworld.com         QuadTech, Sussex, WI USA

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Thursday, July 29, 2004 3:19 AM
To: oracle-l_at_freelists.org
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: RE: Feedback on query for monitoring index usage in 9i

Rich,

metalink Note:160712.1 does much the same thing (it just takes the = clause=20
"where io.owner# =3D userenv('SCHEMAID')" out of the definition of=20 v$object_usage to create a new view that is no longer restricted to the=20 current schema).

mvg/regards

Jo

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Jul 29 2004 - 12:28:12 CDT