Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle Database server. Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well-tested, well-illustrated by clear examples, and sure to improve your ability to make an impact on your day-to-day work with Oracle.
Secret ORACLE is the definitive guide to undocumented and partially documented features of the ORACLE database server. This book will improve your efficiency as an ORACLE database administrator and enable you to master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Topics covered include: The MERITS performance optimization method, which extends the state-of-the-art wait event tuning paradigm. Controlling processes of an ORACLE instance with the fragmentarily documented ORADEBUG command to trace SQL statements as well as wait events and dump process state, call stack, and hang analysis information. Tracing the cost based optimizer to understand its cost calculations and decisions. Understanding hidden parameters that govern Automatic PGA Memory Management. Leveraging undocumented features of the Oracle10g/11g scheduler and other partially or fully undocumented PL/SQL packages, such as DBMS_SYSTEM, DBMS_SUPPORT, and DBMS_UTILITY.
Backup and recovery are mission-critical DBA tasks, and it is critical that every Oracle professional develop a RMAN strategy that guarantees recoverability while minimizing unplanned downtime. RMAN is one of the world's most sophisticated backup and recovery tools. It is robust and complex with thousands of options. This landmark book demonstrates, by example, how to create a successful backup and recovery infrastructure using RMAN. This book also contains links to RMAN video tutorials and a download of working RMAN scripts to guide users through full automation of a backup strategy. Together, backup and recovery are the single most important combined DBA activity, and it is crucial that you master the RMAN and Data Pump Import utilities to protect against catastrophic data loss. Written by practicing Oracle DBAs with years of RMAN experience, this is a pragmatic approach to RMAN, focusing less on theory and more on real-world, practical RMAN tools, tips and techniques. This Oracle backup and recovery book is unique because it provides real-world examples on how to use RMAN and other tools to protect your mission critical data. Even with reliable mirrored disks, your important Oracle database is still at-risk from from software corruption, user error and hardware failures. This book details Oracle RMAN best practices and shows the best ways to minimize backup and recovery time, which is critical for maximizing system availability This is the definitive RMAN reference that guides you, step-by-step, through all of the techniques for Oracle backup and recovery, from simple cold backups to complex incremental backups. Experienced RMAN experts guide you through the installation, setup and configuration for a complete RMAN backup and recovery infrastructure using proven techniques and Oracle best practices. Best of all, you be given the opportunity to learn from supplemental video tutorials and working examples how to recover from every possible data scenario. This book has step-by-step checklists that you can follow to guide you through a complex recovery with minimal unplanned system outages. This is an indispensible RMAN reference for every professional DBA who needs to ensure that they understand every possible backup and recovery strategy. It also contains a download of working RMAN scripts to help you easily automate and monitor your RMAN backups.
Now in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised fourth edition covers the developments and new features up to Oracle Database 21c. Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more. All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book’s proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database’s most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career. What You Will Learn Identify and effectively resolve application performance issues and bottlenecks Architect systems to leverage the full power and feature set of Oracle’s database engine Configure a database to maximize the use of memory structures and background processes Understand internal locking and latching technology and how it impacts your system Proactively recommend best practices around performance for table and index structures Take advantage of advanced features such as table partitioning and parallel execution Who This Book Is For Oracle developers and Oracle DBAs. If you’re a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you’re a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.
One of the biggest challenges that IT departments currently face is how to migrate their non-Oracle databases to Oracle platform with limited budget, staff, and time constraints. In order to meet these needs, Oracle originally developed an excellent tool called the Oracle Migration Workbench (OMWB). As the latest and greatest enhancement to migration software, Oracle has provided the new version of migration tools along with a full development environment with the SQL Developer software with Oracle 10g and 11g database releases as the method of choice to accomplish these daunting tasks. This comprehensive guide to these new Oracle migration tools will be valuable to all database professionals who are challenged with the task of migrating their non-Oracle databases to the Oracle 10g and 11g platforms. This text will provide the blueprint and implementation details as well as expert hands-on tips and techniques on how to use this new migration tool to quickly migrate non-Oracle databases to the Oracle 10g database environment. Topics will include a detailed discussion of these tools including coverage of both SQL Developer and the Oracle Migration Workbench installation and configuration process, techniques on how to best use the editors for parsing non-Oracle SQL and stored procedures to map to the Oracle SQL and PL/SQL code, problem resolution and troubleshooting during the migration process, and testing procedures after the initial migration has been completed. This book distills the very complex and technical challenges of how to best migrate your non-Oracle database into an easily digested format with clear step by step techniques that all database professionals can implement right away.
Oracle Core: Essential Internals for DBAs and Developers 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. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica
Based on Oracle8i, release 8.1, this concise book contains detailed, hard-to-find information about Oracle internals (data structures, algorithms, hidden parameters, and undocumented system statistics). Main topics include waits, latches, locks (including instance locks used in parallel server environments) and memory use and management.
Oracle experts know that PL/SQL tuning makes a huge difference in execution speed. As one of the world's most popular and respected experts, Dr. Tim Hall shares his secrets for tuning Oracle PL/SQL. This indispensable book shows how to hypercharge Oracle applications gaining as much as 30x improvement in execution speed using under-documented code tricks. Packed with working examples, learn how to re-write SQL into PL./SQL and how to use advanced Oracle bulk array processing techniques to achieve super high performance. You can save your company millions of dollars in hardware costs by making your applications run at peak efficiency. Targeted at the Senior Oracle DBA and developer, this advanced book illustrates powerful techniques that can make PL/SQL run faster than ever before. This book is not for beginners and should only be purchased by seasoned Oracle professionals who must turbocharge their applications. Your time savings from a single script is worth the price of this great book.
