Hi,
We have a 3TB oracle db. 24x7 operation with data constantly coming in
to the DB. Users from all over the world use a web based applicaton to
query and work on the data.
Out transaction performance is quite good but our query performance
sucks. looking up by ids and some combinations of search critera
return ok but some never return. We indexed the db for a lot of
combinations and we materialized some views and that helped a little.
So far we haven't penalized our transaction throuput but if we
continue this path, our transaction performance will suffer.
We are looking into a third party indexing solutions. We are talking
to Omnidex.
Third party indexing solutions claim a dramatic performance
improvement for
people in our situations.
If any of you are using any third party indexing solutions on oracle,
please share your experiences.
Thank you very much,
Chuck Chekuri
DBA Manager
Vizional Technologies, Inc.
Santa Monica, CA - 90405