Solution : https://service.sap.com/sap/support/notes/923099 (SAP Service marketplace login required)
Summary :
Database performance issues linked to enqueues in Oracle sessions on OBJ$ in RAC environments with Oracle 9.2.0.6 or earlier are typically due to known Oracle bugs 4220161 and 4312871. These bugs cause SMON deadlocks by trying to clean non-existent objects. The most common workaround involves installing Oracle patch or patch set 9.2.0.7, depending on the operating system and specific Oracle version in use. For a permanent resolution, upgrading to patch set 9.2.0.8 is recommended. This upgrade will address the root cause and ensure that performance issues related to these bugs are completely resolved.
Key words :
real application cluster installation, encountered oracle bug 4220161 orbug 4312871, -existant objectsbug 4312871 - smon deadlock, bug 4220161 - smon deadlock, internal table obj$, operating system platform, symptom database performance, database monitor st04n, exclusive tx lock, oracle session overview
Related Notes :
| 745639 | FAQ: Oracle enqueues |