Skip to Main Content
  • Questions

  • Notification mail from database server

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: August 20, 2016 - 7:35 am UTC

Last updated: August 25, 2016 - 2:50 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi team,

I have manually check the tablespace size daily basis now i want to configure the script which check the tablespace size and if the size is less than 10GB then it will send a mail to mai Id So,

Which things we need to configure on server level like poxy, smtp server details?
Which things we need to configure on database level like mailid password..?

How can i do this if any script with you saying the same pls provide us ?

Thanks

and Connor said...

For simple emails, UTL_MAIL is probably easiest. Just set smtp_out_server and you're pretty much ready to go.

Example here

https://oracle-base.com/articles/10g/plsql-enhancements-10g#UTL_MAIL


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

OEM

Laurent Schneider, August 24, 2016 - 8:33 am UTC

to check the tablespace size, there is nothing better then Cloud Control

http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html


Connor McDonald
August 25, 2016 - 2:50 am UTC

Agreed
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.