Looking for effective Bitmap Index Strategy

I have some questions on how to establish an effective strategy to use bitmap indexes with 7.3.4.3.

We have recently applied the 7.3.4.3 patchset, upgrading from 7.3.4.0. I would like to use the bitmap indexes where ever possible. This database supports a PeopleSoft installation and I need to get better performance for the business.

When we started running with the patchset, we received an ORA-600 (I opened a TAR) that was fixed by setting the v733_plans_enabled to FALSE. Then last night we started getting ORA-600[20003]. According to Oracle, the work around for this is to "not used" bitmap indexes. I had added one more to the table yesterday. This table then had four bitmap indexes on it. We had three bitmap indexes on this for over 10 days.

There are a lot of things to like about bitmap indexes, fast query performance, small size. But these ORA-600 are starting to be a REAL nuisance.

Has anyone out there developed a strategy for 7.3.4 and bitmap indexes. The environment is 7.3.4.3 running on IBM RS/6000 AIX 4.3.1,

Thanks
  James

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 11:10:25 CST