Error Found In ADDM Report
I am facing an issue in my OS physical memory shooting upto 99% in AIX bos. When analyzing the ADDM report, we have found the following errors.
DB Version : Oracle 11g R1 (Ver 11.1.0.7)
OS : AIX 6.1
RAC Environment
Looking for expertise advise on the below points:
Finding 6: Interconnect Buffer Busy Impact is .05 active sessions, 11.78% of total activity. -------------------------------------------------------- Read and write contention on database blocks was consuming significant database time in the cluster. Recommendation 1: Application Analysis Estimated benefit is .05 active sessions, 11.78% of total activity. ------------------------------------------------------------------- Action Verify that the set of services used by the application to connect to the database are optimally distributed if response time is critical.