Written by some of the world's top authors, this exciting eBook provides you with everything that you need to know to manage Oracle storage. Explained are how to monitor and reduce disk I/O, how to set up tablespaces for maximum efficiency, and how to define Oracle tables and indexes to make the most efficient use of disk storage. Not for the beginner, this is a guru level advanced Oracle handbook with highly detailed explanations of Oracle storage internals. This eBook is laden

The first part of Special Edition Using Oracle 11i introduces the Oracle ERP applications and R11i concepts. The reader is then educated on proven techniques for implementing these complex and integrated systems. Configuration and usage of each of the financial, distribution, manufacturing, HRMS, and projects applications are covered, followed by a discussion of working with Oracle Support, consulting firms, and compatible software vendors. The appendixes review the employment market, consulting opportunities, and provide the reader with an implementation checklist. All of R11i's new features are covered in-depth and in practical terms. Not only will readers understand Oracle's new capabilities, they will be able to apply them right away.

Identify and Resolve System Bottlenecks Quickly Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. This exclusive Oracle Press guide explains how to take full advantage of the revolutionary Oracle Wait Interface (OWI) to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially. Get extensive details on all the OWI features, including the wait event views, their applications, and the extended SQL trace file. This invaluable resource will help you maximize the most advanced diagnostics tool available and minimize processing time. *Identify performance problems using wait event statistics *Monitor session-level wait events and collect historical data for root cause analysis *Interpret common I/O-related wait events *Diagnose and solve problems related to locking and serialization *Analyze latency-related wait events *Identify and resolve bottlenecks in the Oracle Real Application Clusters environment *Learn about the Oracle Database 10g revolutionary approach to performance diagnostics and tuning

Master all the powerful features of Oracle9 i 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 Oracle9 i . This is a must-have reference for all Oracle professionals.

If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your applications. After an overview of the topics you need to know in order to use the Oracle database effectively, you'll get helpful tips, techniques, code samples, and examples written in Oracle Database 10g.

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. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are �HA Workshops,� step-by-step instructions to get you through certain implementations, plus real-world inspired case studies

This comprehensive guide focuses on utilizing XML technologies within Oracle's XML-enabled products, with emphasis on XML standards, their usage and best practices.

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you�ll get the fundamentals applicable to all Oracle database releases. We start out by giving you an overview of database fundamentals with an Oracle Database 10g flavor, then move into the Structured Query Language (SQL), the delivery mechanism coming to a computer screen on your desktop. Next, we look at the job of the Oracle Database 10g gatekeeper�the DBA, or database administrator. Then come chapters on networking in the Oracle Database 10g world, backup and recovery, PL/SQL, Java, and XML. We finish the journey with a look at very large database features of Oracle Database 10g. This is an area Oracle has spent some time developing over the past few releases. Information repositories can be likened to jumbo jets�the bigger they are, the more difficult they are to maneuver