I think you can use UTLBSTAT and UTLESTAT scripts to monitor the database.

There are other scripts out there as well including some at the link to your left titled Oracle Scripts.


To e-mail yourself if an error appears in the alert log - I'm not sure, our company wrote one but it was on UNIX and unix scripting is somewhat different I think.