Many databases are large and complex, making them very difficult to manage. In turn, data can become difficult to access, expensive to store, and even damaged or destroyed. Oracle 9i offers new functionality for the Oracle database system, ensuring that the database runs quickly, efficiently, and reliably.
Oracle 10g: Database Administrator: Implementation and Administration (DBA1) uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.
This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.
Attain real solutions for current availability challenges. Based on a “DBA-centric” approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account.
This book offers Oracle DBAs training appropriate for understanding and handling PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Written by a field expert, this book answers common questions and misunderstandings that arise from use of PeopleSoft on an Oracle database. The result is a highly effective training manual for any Oracle DBA charged with the maintenance of a PeopleSoft system.
Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics.
The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.