different results occur when something is different.
only YOU can compare & contrast between the server that is "working" & the server which is not behaving as you desire.
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
And could you tell me where can I look for differences? In Oracle Enterprise Manager, all data relating with the tablespace is the same. I tried using GET_THRESHOLD function and all the same. Where can I find additional information about a tablespace?
Sorry for inconvenience. Tablespace is 99.2% used. I have setted the Threshold Critical to 2%. So it should send a message, isn't it?
Perhaps it only sends the message when the threshold is crossed?
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
Thank you HermantKChitale for your answer. I will find information about that patches.
I usually use the same datafiles configuration in all tablespaces:
AUOTEXTEND activated with a 100 MB increment with a Maximum File size of 32767MB.