Re: Database Time Spent Waiting

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 21 May 2010 19:46:35 +0530
Message-ID: <AANLkTim0kjfCnI7n-_a-d5_159_2AqOVQ3ZonXOQwscX_at_mail.gmail.com>

I guess so..or is there any other tool used for monitoring and thats causing the problem..

On 23 April 2010 18:43, Jay Hostetter <hostetter.jay_at_gmail.com> 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
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 21 2010 - 09:16:35 CDT