8 Replies Latest reply: Jul 17, 2013 4:43 AM by RobertoMG RSS

    Email notification doesn't work in a specific tablespace.

    RobertoMG

      Hello,

       

      I have a Oracle 10gR2 Version: 10.2.0.5.0. I'm having problems to receive emails notifications in a specific tablespace. I created a Rule Notification for "Tablespace Space Used (%)". I know the rule and metrics are ok. How?

       

      1)  At another tablespace, I create a specific Threshold for Tablespace Space Used (%) and I set the Warning Threshold to 1%, and Critical Threshold to 2%. After some minutes, I receive an email with the Critical message because the tablespace have a 60% of space used. I do the same test with the other tablespace and no email received.

       

      2) I have two servers with the same database (only data changes) and in one server its works , not in the other server.

       

      This is the information for the "bad" tablespace:

       

      NameBAD_TABLESPACE
      Bigfile tablespaceNo
      StatusReadWrite
      TypePermanent
      Extent Managementlocal
      https://njpl09:1158/em/cabo/images/t.gif
      https://njpl09:1158/em/cabo/images/t.gif

      Storage

      https://njpl09:1158/em/cabo/images/t.gif
      https://njpl09:1158/em/cabo/images/t.gif
      Allocation TypeAutomatic
      Segment Space ManagementAutomatic
      Enable loggingYes
      Block Size (B)

      8192

       

      It have 45 .dbf datafiles. Almost all of them are 100% full (32GB max)

      Locally Managed, Permanent, Read Write mode. an Logging enabled.

       

      Any ideas? suggestions or miracles?

       

      Thanks!