What tools would you recommend for monitoring the general health and performance of an oracle database. How do you ensure database issues are picked up and resolved quickly.
+2
A:
Have you looked at TOAD. If you get the edition with the DBA module, there are heaps of monitoring & optimization features.
Mike Thompson
2008-09-01 01:18:06
+1
A:
Statspack and AWR are part of oracle (statspack is pre-oracle10 and AWR is 10g+) They are good for looking at how your db is performing. There are also a number of 3rd party tools available, can't say any of them is better than the rest as they all do the same thing IMHO.
MichaelN
2009-03-10 15:37:36