Darl Kuhn Pořadí knih (chronologicky)

Speed up the execution of important database queries by making informed choices about indexing. Learn to select the correct index types for various scenarios and avoid pitfalls that could hinder performance. Maintaining indexes is crucial for ensuring consistent and predictable query responses throughout an application's lifecycle. This resource focuses on the index, a key database structure central to performance concerns. As database system performance remains a top priority in IT, administrators face challenges due to the growing demand for access driven by the proliferation of devices in our connected world. A robust indexing strategy that leverages vendor-specific features is essential for optimal database performance. Many databases fail to fully utilize the extensive data access mechanisms available. This concise guide consolidates vital information on indexing, making it easy to reference and understand. Discover the different types of indexes and their best applications, recognize when queries aren't utilizing indexes effectively, and manage indexing for peak performance. Gain confidence in using the In Memory column store feature as an alternative access path to enhance performance. This resource serves as a comprehensive guide to mastering the fundamental performance optimization structure in Oracle Database.

In this book, Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. Oracle RMAN Recipes helps you take advantage of all that RMAN has to offer. This handy guide demystifies the steps required to protect your business data. It provides ready-made and example-based solutions to common (and some not-so-common) backup and recovery operations.

Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital. The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as: Implementing a recovery catalog Creating and running RMAN scripts Configuring input/output channels Taking a full database backup Backing up tablespaces and datafiles Taking incremental backups Recovering lost datafiles The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.