RE: Softtree's DBTools
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <poelsb@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Nov 2004 10:55:12 -0600
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
