Oracle is an enormous system, with myriad technologies, options, and releases. Most users - even experienced developers and database administrators - find it difficult to get a handle on the full scope of the Oracle system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies. This book distills the enormous amount of information about what Oracle is, where it came from, and what the latest releases do -- and packages it into a compact, easy-to-read volume filled with focused text, illustrations and helpful hints. It explains what's new and important about Oracle's revolutionary releases, Oracle8 (the "object-relational database") and Oracle8i (the "Internet database").
It covers: * Oracle products, options, and overall architecture * Installing and running Oracle (creating databases, configuring Net8, starting up and shutting down Oracle) * Oracle data structures * Managing Oracle (implementing security, using the Oracle Enterprise Manager, dealing with fragmentation and reorganization, and performing backup and recovery) * Oracle networking * Monitoring and tuning * Multi-user concurrency and online transaction processing (OLTP) * Special issues for high-availability systems * Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle * Data warehousing * Distributed databases * Extensions for Oracle8 and Oracle8i, including the latest Java and Web technologies It also includes an appendix full of references to additional online and offline resources. For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies. But even if you already have a library full of Oracle documentation and books, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
Table of Contents 1. Introducing Oracle 2. Oracle8 Architecture 3. Installing and Running Oracle 4. Data Structures 5. Managing Oracle 6. Oracle8 Performance 7. Multiuser Concurrency 8. Oracle8 and Transaction Processing 9. Oracle8 and Data Warehousing 10. Oracle8 and High Availability 11. Oracle8 and Hardware Architecture 12. Distributed Databases and Distributed Data 13. Oracle8/Oracle8i Extensions 14. Oracle8i and the Web Appendix - Additional Resources
- ISBN10 0596107471
- ISBN13 9780596107475
- Publish Date 1 November 2007 (first published 7 December 1999)
- Publish Status Out of Print
- Out of Print 27 September 2022
- Imprint O'Reilly Media
- Edition 4th ed.
- Format eBook
- Pages 408
- Language English