CHAPTER 22
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’ll cover the following troubleshooting activities:
- 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 SQL statements
- Identifying and resolving locking issues
- Troubleshooting open-cursor issues
- Investigating ...
Get Pro Oracle Database 12c Administration, Second Edition 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.
