Oracle Server performance monitoring tools

Question

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.

Answer 1

Have you looked at TOAD. If you get the edition with the DBA module, there are heaps of monitoring & optimization features.

Answer 2

No special tools needed. Your users will generally inform you of performance problems in a very timely fashion. A good DBA should be able to solve/prevent them.

Answer 3

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.

Answer 4

You could have a look at Oracle scripts/tools, like ADDM or STATSPACK. Or use a more complete solution, like :

• Monocle
• Yabox
• Foglight
• Nagios
• Ion

Answer 5

Check out DBTuna http://www.dbtuna.com for 24x7 deep-dive monitoring