OK, I've removed the bitmap indexes and replaced them with default
b-tree indexes. I've left the bitmap indexes in as comments.
While bitmap indexes perhaps make sense for objects and their
friends, I certainly don't see why they're needed for apm packages!
How many packages are there in a full installation? A few dozen?
The APM spends all if its time parsing .info files with a Tcl
parser, not extracting rows from the package, package version, and
package files tables! A b-tree index is certainly sufficient, and I
bet that for some of the queries Oracle selects a sequential scan
anyway (indexed scans can actually be slower on small tables than a
sequential scan).
