Index Usage Monitoring

2001-01-30 Thread PRINCE, PATRICK W.
We have a purchased application with over 1,300 indexes. Can someone suggest a method to monitor the system to determine which indexes are actively being used over time? I'm assuming that some are old/not necessary and would like to save the overhead of maintaining them. Oracle 8.0.6 Patrick

Re: Index Usage Monitoring

2001-01-31 Thread jkstill
Pine Cone Systems has software to do this. There is also another company that has software to do this, but I can't recall their name at the moment. If you talk to Pine Cone, ask them who their competitors are. Be forewarned, this stuff is very expensive. Jared On Tue, 30 Jan 2001, PRINCE, PA

RE: Index Usage Monitoring

2001-01-31 Thread Mark Leith
One of our partners (Bit by Bit) has a SQL tuning tool, that will also do this. The logic is that it looks at all sql statements stored in the database, generates all explain plans and stores them in a background database (BDE I think). It can then tell you which indexes are used. Not very useful

Re: Index Usage Monitoring

2001-01-31 Thread K Gopalakrishnan
Hi ! Starting from Oracle9i there will be a new view called V$OBJECT_USAGE (Name may change ??) can be used to monitor the index usage (!!) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __

RE: Index Usage Monitoring

2001-01-31 Thread Smith, Ron L.
V$access appears to be pretty unreliable. V$db_object_cache does not appear to carry indexes but does have some good information on tables. -Original Message- Sent: Wednesday, January 31, 2001 2:51 PM To: Multiple recipients of list ORACLE-L And starting with the time immemorial, there

RE: Index Usage Monitoring

2001-01-31 Thread Gogala, Mladen
And starting with the time immemorial, there is the V$ACCESS table which shows the parse locks that the application has. It also shows the indexes (indices) used by the application. -Original Message- Sent: Wednesday, January 31, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Hi

RE: Index Usage Monitoring

2001-02-05 Thread Vadim Gorbounov
Hi, Why not to use otrace? Of cource, you may need some space to save trace results, but you'll definitely get complete statistics. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, January 30, 2001 3:57 PM To: Multiple recipients of list ORACL

RE: Index Usage Monitoring

2001-02-05 Thread exu
eleen Xu/NNIB/NNNG) Subject: RE: Index Usage Monitoring Hi, Why not to use otrace? Of cource, you may need some space to save trace results, but

RE: Index Usage Monitoring

2001-02-05 Thread Mark Leith
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: Eveleen Xu/NNIB/NNNG) Subject: RE: Index Usage Monitoring Hi, Why not to use otrace? Of cource, you may need some space to save trace results, but you'll definitely get complete statistics

RE: Index Usage Monitoring

2001-02-05 Thread Vadim Gorbounov
cc: (bcc: Eveleen Xu/NNIB/NNNG) Subject: RE: Index Usage Monitoring Hi, Why not to use otrace? Of cource, you may need some spa

RE: Index Usage Monitoring

2001-02-06 Thread Trassens, Christian
e 2001 16:31 > Para: Multiple recipients of list ORACLE-L > Asunto: RE: Index Usage Monitoring > > Hi, > Why not to use otrace? Of cource, you may need some space to save > trace results, but you'll definitely get complete statistics. > > Vad