Practical Oracle8i?: Building Efficient Databases

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.