Home » Server Options » RAC & Failsafe » Database Time Spent Waiting Warning (Oracle RAC 11g (11.2.0) three node RAC, RHEL 5.7)
Database Time Spent Waiting Warning [message #539539] Mon, 16 January 2012 22:20 Go to next message
Modaya
Messages: 10
Registered: September 2008
Location: Colombo
Junior Member
Dear all,

i'm keep on getting below error every morning in my Database.this indicate in Grid control every morning.

Metrics "Database Time Spent Waiting (%)" is at 34.336 for event class "Concurrency"

Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other"

Metrics "Database Time Spent Waiting (%)" is at 44.78 for event class "Other"


i need to know, this is something that i should consider as a critical warning and how can i solve this .

also if any one can give me a background , why this warning giving, that would be great.
Re: Database Time Spent Waiting Warning [message #539541 is a reply to message #539539] Mon, 16 January 2012 23:23 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to follow a course on Oracle Performances & Tuning.
As a starter you can read Database Performance Tuning Guide

EM is a tool to simplify the life of a DBA, not to replace a DBA. This means you MUST be a DBA before using it.

Regards
Michel

Previous Topic: RAC Maintenance
Next Topic: Oracle FailSafe & Vmwear
Goto Forum:
  


Current Time: Thu Mar 28 03:14:13 CDT 2024