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 ...
Get Oracle SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
