O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

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

Chapter 20. Database Troubleshooting

Database troubleshooting is a general term that can apply to vast a range of topics, such as resolving storage issues, investigating sluggish performance, or monitoring database objects. SQL is often the first tool you'll use to get an idea of what might be amiss in the database. Therefore, you must be familiar with SQL techniques for extracting and analyzing database information.

The recipes in this chapter are mainly for DBAs. However, if you're a developer, many of these topics will indirectly impact your ability to work efficiently with the database. Knowing the solutions to the problems described in this chapter will give you a better understanding of the Oracle architecture and will also arm you with information ...

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