Quote:
Originally Posted by
Shedonyourlight
Anyone who knows where I can find home made scripts that monitoring a oracle database ?
Yes - and the answer is: practically anywhere.
You might want to search here (and some myriad of other, similar forae) for monitoring processes, checks of tablespaces, ways of running checks automatically and sounding an alarm if some threshold value is reaches, etc..
What you also might do is to put some more effort in learning about what you are going to monitor:
i.e.an Oracle database has (at least) two sorts of processes, the database worker processes and the listener(s). You perhaps want to monitor these separately and you most probably will have different kinds of responses to one (set of) processes failing. Therefore, saying you want to "monitor processes" is a bit more multi-faceted than just checking if a process runs. And this comes from a publicly known database-ignorant like me who has only a passing knowledge of what a database in general (and Oracle in particular) does.
If you don't even know such a basic fact (and many more equally basic facts) you should learn about your subject enough to be at least able to ask educated questions. That would be a more fruitful effort than to aimlessly download scripts which you probably have no idea about, not how they work and not even which problem they are supposed to solve.
I hope this helps.
bakunin