INTRODUCTION TO ORACLE PHYSICAL DESIGN Preface Relational Databases and Physical Design Systems Analysis and Physical Database Design Introduction to Logical Database Design Entity/Relation Modeling Bridging between Logical and Physical Models Physical Design Requirements Validation PHYSICAL ENTITY DESIGN FOR ORACLE Data Relationships and Physical Design Massive De-Normalization: STAR Schema Design Designing Class Hierarchies Materialized Views and De-Normalization Referential Integrity Conclusion ORACLE HARDWARE DESIGN Planning the Server Environment Designing the Network Infrastructure for Oracle Oracle Network Design Oracle Disk Design Conclusion ORACLE INSTANCE DESIGN SGA Parameter Components Designing the Shared Pool Library Cache Usage Measurement Oracle Event Waits The Shared Pool Advisory Utility Designing the Data Buffers Design with the Data Buffer Hit Ration (DBHR) Pinning Packages in the SGA ORACLE TABLESPACE DESIGN Sizing Oracle Data Blocks The Evolution of Oracle File Structures Design for Oracle Segment Storage Automatic Segment Space Management Replication Design Conclusion ORACLE TABLE DESIGN Table Replication Design Oracle External Tables Design with Materialized Views Oracle Object Structures Design with VARRAY Tables Using Nested Tables Conclusion ORACLE INDEX DESIGN Index Design Basics Evaluating Oracle Index Access Methods Designing High-Speed Index Access Oracle Optimizer and Index Design Physical Row-Ordering and Index Design Using Multicolumn Indexes How Oracle Chooses Indexes Index Design for STAR Schemas Indexing Alternatives to B-Tree Indexes Design for Oracle Full-Index Scans Basics of Function-Based Indexes Invoking the Full-Index Scan with a Function-Based Index How to use Oracle9I Bitmap Join Indexese Measurement Oracle Event Waits The Shared Pool Advisory Utility Designing the Data Buffers Design with the Data Buffer Hit Ration (DBHR) Pinning Packages in the SGA ORACLE TABLESPACE DESIGN Sizing Oracle Data Blocks The Evolution of Oracle File Structures Design for Oracle Segment Storage Automatic Segment Space Management Replication Design Conclusion ORACLE TABLE DESIGN Table Replication Design Oracle External Tables Design with Materialized Views Oracle Object Structures Design with VARRAY Tables Using Nested Tables Conclusion ORACLE INDEX DESIGN Index Design Basics Evaluating Oracle Index Access Methods Designing High-Speed Index Access Oracle Optimizer and Index Design Physical Row-Ordering and Index Design Using Multicolumn Indexes How Oracle Chooses Indexes Index Design for STAR Schemas Indexing Alternatives to B-Tree Indexes Design for Oracle Full-Index Scans Basics of Function-Based Indexes Invoking the Full-Index Scan with a Function-Based Index How to use Oracle9I Bitmap Join IndexesBR>Using Multicolumn Indexes How Oracle Chooses Indexes Index Design for STAR Schemas Indexing Alternatives to B-Tree Indexes Design for Oracle Full-Index Scans Basics of Function-Based Indexes Invoking the Full-Index Scan with a Function-Based Index How to use Oracle9I Bitmap Join Indexes.