Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g tablespace % full metric

Re: 10g tablespace % full metric

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 29 Nov 2007 08:16:52 -0800
Message-ID: <1196353005.247426@bubbleator.drizzle.com>


Chuck wrote:
> There was a change in 10g in how the tablespace % full alerts trigger
> and get cleared. It began being handled by the DB itself instead of the
> EM agent. Here's my question. When you set warning and critical
> thresholds via grid control for a 10g database, shouldn't that set the
> metrics in the DB without having to manually use the DBMS_SERVER_ALERTS
> package? In my case it is not. I have tried running a clearstate of the
> agent, then added a pair of thresholds for a specific tablespace, but a
> query of DBA_THRESHOLDS does not show my changes. It just shows the
> defaults.
>
> TIA.
It probably is working without using DBMS_SERVER_ALERTS but you may well be looking at the fact that the webcache is still holding the original value. Try stopping and restarting the webcache.

Because, as you indicate, it should.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 29 2007 - 10:16:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US