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:
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?
As the 'information' you provide is completely inadequate, no one can see why one server alerts works and the other doesn't.
Your question boils down to 'My car is broken, please fix my car',
My suggestion is you learn to ask better questions.
Eg: No one can determine from here how much of those tablespaces is occupied, as you didn't provide any metrics.
Senior Oracle DBA
Then it should do the same in all tablespaces isn't it? Like sb92075 said: "different results occur when something is different.". The only thing different between the tablespaces is the process running on it. I have some process running in my "bad_tablespace" that it load a big amount of data. I detected when I stop all the process, I start again to receive the emails. I can't find information about that.
Could be possible the high data load of a tablespace might affect to notification emails?
Oracle has released some patches for Tablespace Used alerts.
See their Support Note
Oracle Recommended Patches For Tablespace Monitoring using the Tablespace Space Used % metric [ID 849498.1]
How have you configured AUTOEXTEND for the datafiles in the tablespace ? Is it different for other tablespaces ?
Hemant K Chitale