An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.The new edition of this classic book, Oracle Essentials, 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more.Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracle's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. The book contains chapters on:
- Oracle products, options, and overall architecture for Oracle 10g and prior recent releases
- Installing and running Oracle: how to configure, start up, and shut down the database, and various networking issues
- Oracle data structures, datatypes, and ways of extending datatypes, with an introduction to Oracle objects (e.g., tables, views, indexes)
- Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery
- Oracle performance: characteristics of disk, memory, and CPU tuning
- Multi-user concurrency, online transaction processing (OLTP), and high availability
- Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle
- Data warehousing and distributed databases
- Network deployment: using Oracle as an Internet computing platform and for grid computing
- What's new in Oracle 10g: a summary of the database changes described in the book
Oracle Essentials, 3rd Edition: Oracle Database 10g was written for anyone whose job involves managing or building systems using Oracle DBMS technology or working with staff that uses Oracle technology. This book is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.