I've got a couple of queries of wf_java_deferred "where msg_id = :1" that are generating 1+ billion ( that's a B ) physical IOs per day in an HR instance. It's clear to me that this table needs an index on msg_id, however Oracle support has been unable to provide the fairly obvious "YES" to creating the index, this is on an SR that's months old. They've had our apps developers run scripts to detect and create missing indexes, however none of the scripts work as advertised. Latest from them was 11 weeks ago, sending this to developer for comment."
Does anyone else have a similar situation? Maybe I should try to get the SR escalated?