8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Tablespace Thresholds and Alerts (DBMS_SERVER_ALERT)


Tim said...

If a threshold for a tablespace is set via SET_THRESHOLD, how can we remove the threshold if it is no longer needed? Could you give an command example?

Tim... said...

Hi.

In the article it says, "Setting the warning and critical levels to '0' disables the notification.", so use the same method, but set the values to 0.

Cheers

Tim...

narendra said...

hi could you please provide how to retrive this procedure (revert back) (or) let me know if we run this procedure is there any effect to the db and also please help me how to get a alert every day.

And also please let me know what is LE and GE.

thanks,
T.Narendra

Tim... said...

Hi.

Most of your questions were already answered in the article. I rearranged it is a little to make things more obvious. read the article again and you will see your answers.

Cheers

Tim...

Ceyhun said...

I want set default threshold to tablespace..how can I do?

Tim... said...

Hi.

The default is one setting for all tablespaces, so you can't set a default for one tablespace. It is the default setting for all tablespaces. To reset a tablespace back to defaults, set the critical and warning levels to NULL.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.