Oracle Manage/Monitor Databases
Posted on 2014-04-23
Need your assistance/guidance, in managing/monitoring my 6 databases, any sql, script, doc or weblink will be much appreciated.
Where needs some help, along with some emailing functionality too:
1. alert log: monitor/log all ora- errors.
2. tablespaces; monitor/log for any crossing the decided threshold
3. hanged or locked sessions
4. long running quires
5. space management: eaten by trace + audit file
Please feel free to add, if I'm missing anything over here, just a FYI, was trying to install OEM for 11g & 12c too, but struggling big time and for last 3 weeks, working with Oracle Support ... and nothing yet, as expected, they can't even able to assist to cleanup/unistall and then reinstall.
Any way, please share/assist, if you are already monitoring/managing these, but in a proactive manner, getting alerts/emails, before hand.
Thanks in advance.