Database Tuning (MOSC)

MOSC Banner

Error Found In ADDM Report

edited May 2, 2010 6:12AM in Database Tuning (MOSC) 7 commentsAnswered
 Hi All,

 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center