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
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
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
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.
__
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
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
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
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
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
cc: (bcc: Eveleen Xu/NNIB/NNNG)
Subject: RE: Index Usage Monitoring
Hi,
Why not to use otrace? Of cource, you may need some spa
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
11 matches
Mail list logo