Re: Database Time Spent Waiting

I'm following up on this post in case anybody else sees a similar
issue. Oracle support couldn't tell me why my alerts are for zero values.
They stated that since these were not default thresholds, they recommended
that I remove them, which I will do.  I was referred to note 744115.1, but I
wasn't using EM.
I wasn't entirely happy with their answer.  I suspect our customer was
fiddeling around with the EM GUI at one point in a seed database, then they
propagated that seed database to various other databases.  Hence the same
alerts in numerous databases on the same box.

Jay


On Fri, Apr 23, 2010 at 9:13 AM, Jay Hostetter <hostetter.jay@xxxxxxxxx>wrote:

> I didn't see this message come through, so my apologies if it is a
> duplicate post
>
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
> I have a few test databases that are on the same box.  They are reporting
> several hundred "Concurrency" alerts in DBA_ALERT_HISTORY each day.  My
> first thought is that since the databases are rarely used, some scheduled
> jobs are triggering these alerts and I probably need to tweak the
> thresholds.  The customer does not have Grid control or the database console
> setup for these databases.  A sample of recent records in dba_alert_history
> is shown below.  Can somebody explain to me why the alert is triggered for
> this metric when all of my warning_values for "Database Time Spent Waiting
> (%) are set to 30 (in DBA_THRESHOLDS)?  And why do I see so many alerts for
> a value of 0?  It would make sense to see a 0 when the alert is cleared, but
> I don't understand why I see so many zeros in a row.
>
> Thank you,
> Jay
>
> REASON
> TO_CHAR(TIME_SUG METRIC_VALUE
> ------------------------------------------------------------------------------------------
> ---------------- ------------
> Metrics "Database Time Spent Waiting (%)" is at 0 for event class
> "Concurrency"            04-22-2010 13:49            0
> Metrics "Database Time Spent Waiting (%)" is at 0 for event class
> "Concurrency"            04-22-2010 13:38            0
> Metrics "Database Time Spent Waiting (%)" is at 0 for event class
> "Concurrency"            04-22-2010 13:34            0
> Metrics "Database Time Spent Waiting (%)" is at 0 for event class
> "Concurrency"            04-22-2010 13:16            0
> Metrics "Database Time Spent Waiting (%)" is at 0 for event class
> "Concurrency"            04-22-2010 13:13            0
> Metrics "Database Time Spent Waiting (%)" is at 0 for event class
> "Concurrency"            04-22-2010 13:11            0
> Metrics "Database Time Spent Waiting (%)" is at 28.40031 for event class
> "Concurrency"     04-22-2010 13:05   28.4003091
>

Other related posts: