Books

Enterprise Manager 12c (EM12c), Oracle’s newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today’s increasingly chaotic and change-driven IT environment.

Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins.  Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. 
 

This book is about the mathematical foundation of relational databases; it demonstrates how logic and set theory can be used as tools to formally specify database designs, including the data integrity constraints (a main topic of this book). Don't let this scare you of; the book explains the required mathematical concepts with many examples and should be accessible for the regular database professional. It does assume that you are familiar with designing a database.

You'll find three parts in this book:

• Part 1 provides the mathematics. It covers those parts of logic and set theory that are both necessary and sufficient to formally specify database designs and their constraints.
• Part 2 demonstrates the application of these subjects. It gradually develops the formal specification of a ten-table database design that includes over seventy data integrity constraints. You'll also find a treatment of formal query and transaction specification in this part.
• Part 3 is the Oracle specific part. You'll discover that due to poor support of declarative constraints, implementing these in today's SQL DBMS's still poses quite a few challenges. It demonstrates a method—based on database triggers—to implement (multi-row) constraints procedurally. This method has evolved for over 12 years; it is an efficient one and one that cannot be subverted.

 
It is important to understand the mathematical foundation of our database profession. The knowledge contained in this book will, in the end, enable you to better design and implement databases

What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.
 
This book shows you how to do the following:

• Identify performance problems using a systematic and repeatable approach.
• Configure the query optimizer to meet your application performance goals.
• Obtain and interpret execution plans as well as assess whether they are inefficient.
• Apply SQL tuning techniques such as hints, SQL profiles, stored outlines and SQL plan baselines.
• Minimize the impact of parsing without jeopardizing performance.
• Optimize data access, joins and the physical design.
• Improve performance through parallel processing, materialized views, and result caching.

This book is intended for performance analysts, application developers and database administrators who are involved in troubleshooting performance problems of applications based on the Oracle database engine.
No specific knowledge in optimization is required. However, readers are expected to have a working knowledge of the Oracle database engine and to be proficient with SQL.