Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
OEM Grid Control Question

OEM Grid Control Question

2007-09-05       - By Binh Pham

 Back
I'm trying to setup metric/alerts to exclude the UNDO_TBS from being
monitored for the tablespace percent full condition.  However, I'd like to
have "All other tablespaces" to be monitored as before, which means
"warning" > 85% and "critical" > 95%.  



The way I set it up was to add another condition under the "Tablespace Full
Percentage" metric for UNDO_TBS such as that the warning threshold is > 101
and the Critical threshold is also > 101.  However, this does not seem to
work since I'm still getting those alerts on UNDO_TBS.  Grid Control did not
complain about this setup.



Any suggestion?  We're using 10.2.0.2 Grid Control.



Thanks


<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;}
p
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
address
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";
  font-style:italic;}
pre
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:10.0pt;
  font-family:"Courier New";}
span.EmailStyle20
  {mso-style-type:personal;
  font-family:Arial;
  color:navy;}
span.EmailStyle21
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:blue;
  font-weight:normal;
  font-style:normal;
  text-decoration:none none;}
@(protected) Section1
  {size:595.3pt 841.9pt;
  margin:70.85pt 85.05pt 70.85pt 85.05pt;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<div>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>I&#8217;m trying to setup metric/alerts to
exclude the UNDO_TBS from being monitored for the tablespace percent full
condition.&nbsp; However, I&#8217;d like to have &#8220;All other tablespaces&
#8221;
to be monitored as before, which means &#8220;warning&#8221; &gt; 85% and &
#8220;critical&#8221;
&gt; 95%.&nbsp; <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>The way I set it up was to add another
condition under the &#8220;Tablespace Full Percentage&#8221; metric for
UNDO_TBS such as that the warning threshold is &gt; 101 and the Critical
threshold is also &gt; 101.&nbsp; However, this does not seem to work since I&
#8217;m
still getting those alerts on UNDO_TBS.&nbsp; Grid Control did not complain
about this setup.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>Any suggestion?&nbsp; We&#8217;re using
10.2.0.2 Grid Control.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>Thanks<o:p></o:p></span></font></p>

</div>

</div>

</body>

</html>