RE: Feedback on query for monitoring index usage in 9i
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2004 12:28:08 -0500
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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Thursday, July 29, 2004 3:19 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
