O'Reilly logo

Pro Oracle Database 11g Administration by Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  22

images

Database Troubleshooting

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required