What are the performance diagnostic tools in Oracle 11g?

Question

Oracle

Good afternoon.

What diagnostic tools are available in Oracle 11g?
How can I monitor the state of the database server for resource usage?
How to determine that the server is not optimally configured and needs tuning?
Is there any how-to from Orakla on this issue?
Thank you.

Answer 1

Sorry, but you should at least go to the vendor's website.
docs.oracle.com/cd/E11882_01/nav/portal_17.htm - here's a start.
- 2 Day + Performance Tuning Guide
- Performance Tuning Guide
In general, judging by the questions, you should read Database Concepts first (in the same place on the Oracle website), then Tom Kite , and then you can read about the Oracle optimizer .
In parallel, read Oracle's guides on administration and backup.
And only after that, you can be allowed a little bit to the productive bases.
If you are not a professional DBA, but just need a web face with more or less understandable pictures, you can immediately google about Oracle Enterprise Manager, but for a more or less decent analysis, you still cannot do without digging in the guts, analyzing AWR, ASH, etc.

Answer 2

quest software toad + spotlight