Practical Oracle 8i: Building Efficient Databases

• The real-world guide to Oracle database design: what works, what doesn't, and why!
• A holistic view of Oracle: understand how key features interrelate to impact performance, scalability, and manageability.
• Avoid the traps that cause so many Oracle projects to fail!

In this book, one of the world's leading Oracle database consultants covers the real-world design and development issues most Oracle books ignore! Jonathan Lewis presents powerful techniques -- and errors to avoid -- if you want to build databases that meet their objectives, stay on budget, scale to support growth, and are easy to manage. Jonathan Lewis focuses on helping database designers and developers answer two essential questions: "How should I think when designing an Oracle-based application? And, how can I select the most appropriate Oracle features for my application, taking into account their interrelationships?" Drawing upon fifteen years experience as an Oracle database designer and consultant, he delivers an intimate understanding of the Oracle database engine, and all the guidance you need to use its key features most effectively. Coverage includes: tables and tablespaces, indexing, temporary space, files, views, partitioning, lots, simple and collection objects, LOBs, integrity, PL/SQL, autonomous transactions, RLS, PQO and OPS, replication, fallback, and much more. For every Oracle database designer, developer, and manager; and for any professional called upon to maintain or optimize Oracle-based databases.

Jonathan Lewis, one of the UK's leading Oracle consultants, has spent the past 15 years helping people design and implement Oracle database systems -- and correcting mistakes made by the inappropriate use of Oracle technology.