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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ben Poels Sent: Wednesday, November 03, 2004 10:42 AM To: oracle-l_at_freelists.org
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