Chapter 22 Database Troubleshooting

  • Darl Kuhn


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, I will discuss the following troubleshooting activities:
  • Assessing database availability issues quickly.

  • Identifying system performance issues with operating system utilities.

  • Querying data dictionary views to display resource intensive SQL statements.

  • Using Oracle performance tools to identify resource consuming SQL statements.

  • •Identifying and resolving locking issues.

  • •Troubleshooting open cursor issues.

  • •Investigating issues with the undo and temporary tablespaces.

  • •Auditing database activities.


Remote Server Sample Output Audit Trail Trace File Audit Action 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Darl Kuhn 2010

Authors and Affiliations

  • Darl Kuhn

There are no affiliations available

Personalised recommendations