Solution : https://service.sap.com/sap/support/notes/1037755 (SAP Service marketplace login required)
Key words :
st04 --> detailed analyze --> oracle session --> shows buffer busy waits, ziphp-ux pa-risc 64-bit /oracle/oracle 64-bit/oracle 9, terms performance mrp assm buffer busy wait reason, ziphp-ux itanium 64-bit /oracle/oracle 64-bit/oracle 9, zipsun solaris 64-bit /oracle/oracle 64-bit/oracle 9, ziplinux itanium 64-bit /oracle/oracle 64-bit/oracle 9, ziphp tru64 /oracle/oracle 64-bit/oracle 9, ziplinux x86-64 /oracle/oracle 64-bit/oracle 9, ziplinux 32-bit /oracle/oracle 32-bit/oracle 9, oracle 64-bit /oracle/oracle 64-bit/oracle 9
Related Notes :
| 1002062 | Additional merge fix for Oracle 10.2.0.2 |
| 938986 | Oracle Database 9.2: Patches for 9.2.0 |
| 766349 | FAQ: Oracle SQL optimization |
| 712624 | High CPU consumption by Oracle |
| 620803 | Oracle 9i: Automatic Segment Space Management |
| 618868 | FAQ: Oracle performance |