Oracle Core: Essential Internals for Troubleshooting by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less.
Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data.
Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.
What you’ll learn
Who this book is for
Oracle Core: Essential Internals for Troubleshooting is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.
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:
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
A PeopleSoft Survival Guide for DBAs and other technicians
A part of the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. It provides answers to common questions that arise when using PeopleSoft on an Oracle database.
The book begins with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Subsequent chapters explain database structures, connectivity, keys and indexing, the PeopleSoft DDL generation, tablespaces organisation, performance metrics, performance monitoring utilities, and SQL optimization techniques.
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:
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.
This the first book of many to be published under the OakTable Press Label. The lead author, Connor McDonald is a respected member of the OakTable and is a well-known personality both on the Oracle speaker circuit and in online Oracle forums. This book is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively.If you’re brand new to PL/SQL, then you’ll want to take some time to get familiar with the language before tackling this book
Tom Kyte's first book is packed with lots of Oracle insider knowledge including, among other topics, what the various Oracle server processes and files do, what's happening inside the database during a transaction, and the real meaning of the various options available in Oracle's DML and DDL SQL statements. The likely impact of design decisions on application behaviour and performance is also discussed, particularly where this relates to using, or not using, a database feature.
Tom Kyte has produced an excellent guide to building and designing high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. The tools required, optimizing database processes, statement processing and designing an effective schema are all covered.
Co written by Jared Still, Perl for Oracle DBA's is a must for your any DBA. Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable resource.