I have been asked to initiate a performance monitoring of my 40 some databases and I am looking to get some ideas from you dbas out there how do you do that? I would assume
performance monitoring would include: watching for extents, db activity, alert log monitoring, etc.
are there any suggestions to scripts or softwares i can use to actively monitor 50 instances (unix/nt?)
If you have the OEM then you can create events to fire the performance degradation issues to your mail and if you have oracle performance tuning pack installed, then you can take a live performance statistics.