Author Description

If you are an Oracle Database Administrator, you can expect to encounter many storms in your career. Upgrading and dealing with performance issues, software changes, hardware changes, and even application changes can feel like a perfect storm. This book won’t provide you everything you need for a perfect storm. Hopefully it gets you started down the right path and provides the daily knowledge to solve many problems. This might become your trusty snow shovel. To clarify, we have prepared this material which includes approaches, instructions, examples, definitions, best practices, lessons learned and sample scripts to give you the basic insights needed to tune Oracle 19c Databases. Many of the topics contained herein are extracted from our collective real-world experiences. A few topics are more of a discussion giving you something to ponder and look think about how to approach a situation. Other topics would require a much deeper dive than a pocket reference would allow; including tuning of RAC Cluster, Storage, Networking, Operating Systems, RDBMS Internals to name a few. Those are the times when you will need to dig in deep and have more tools at your disposal for blizzard situations. The major focus of this book is performance tuning in the areas of SQL, Init parameters, load testing, AWR analysis, SQL profiles, Optimizer and Concurrency. We hope you find this book exhilarating from the standpoint that is offers real and actionable tools in a single source. Obviously to read the standard documentation you would spend hours reading thousands of pages whereas this pocket reference is short and to the point.