I would like to check the monitor the following information in the database and I need some help on how to query them.

1. Objects getting close to their max extents?
2. Tablespaces running low on free space?
3. User and process limits reached?

I would also like the information to be email or sms to me whenever the limit set has been met. I know that email can be sent thru utl_smtp package, but can sms be sent thru the database directly? I do not plan to use ias wireless for the sms. Please kindly advice... Thanks!