This discussion is archived
8 Replies Latest reply: Jul 17, 2013 2:43 AM by RobertoMG RSS

Email notification doesn't work in a specific tablespace.

RobertoMG Newbie
Currently Being Moderated

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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points