Database troubleshooting is a vague and general term that is applied to a wide variety of topics. It can mean anything from investigating database connectivity issues to detailed performance tuning. In this chapter, the following troubleshooting activities will be covered:
Assessing database availability issues quickly
Identifying system performance issues with OS utilities
Querying data dictionary views to display resource-intensive SQL statements
Using Oracle performance tools to identify resource-consuming ...
