RE: Softtree's DBTools

Don't know much about it but I am in the middle of coming up with an
easy method to determine which indexes are and are not actually being
used in the database.  The process below shouldn't have a big impact on
the db.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
monitor any indexes not in object_usage

every hour...

for all indexes in object_usage that have been used
   increment counter for index (stored in ref table) used by date
   reset monitor index for given index
end loop
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

I have some ideas to improve the process by eliminating indexes that
show consistent usage.  I will put this in my general set of tools I run
on most databases.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ben Poels
Sent: Wednesday, November 03, 2004 10:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Softtree's DBTools

Hi

Saw this product reviewed on orafaq website and took a look at it. It is
inexpensive and has some great Oracle tools: schema or database copy,
create
test sample data, DDL generation, imp/exp to/from different file
formats.

Is anyone using this product. I like the look and feel of it but I got a
lot
of errors in creating the repository and I stopped the index evaluation
tool
after 30 minutes of processing for only 38 indexes.

What do people think of this product?

Ben


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: