CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      Getting Started with Oracle Expert for Rdb
    1.1 Simplifying Your Database Design
      1.1.1      Understanding the Design Hierarchy
      1.1.2      Using Oracle Expert for Rdb Windows
      1.1.3      Using the Sample Database Designs
    1.2 General Information on Using Oracle Expert for Rdb
      1.2.1      Starting an Oracle Expert for Rdb Session
      1.2.2      Ending an Oracle Expert for Rdb Session
      1.2.3      Getting Help
      1.2.4      Handling Oracle Expert for Rdb Errors
    1.3 Using Oracle Expert for Rdb:  Overview of the Basic Steps
    1.4 Using the Directory Window
      1.4.1      Viewing the Design Hierarchy
        1.4.1.1      Viewing More Information
        1.4.1.2      Viewing Less Information
        1.4.1.3      Faster Methods for Viewing Design Elements

  2      Designing Your Database Environment
    2.1 Defining the Workload
      2.1.1      Opening the Workload Window
      2.1.2      Understanding the Workload Definition
      2.1.3      Determining the Frequency and Importance of Workload Elements
      2.1.4      Exiting from the Workload Window
    2.2 Defining the Data Volume
      2.2.1      Understanding the Data Volume
      2.2.2      Determining the Volatility of Data
      2.2.3      Exiting from the Volume Window
    2.3 Defining the Environment
      2.3.1      Understanding the Environment
      2.3.2      Exiting from the Environment Window
    2.4 Generating the Output Design Elements
      2.4.1      Generating the Physical Schema
      2.4.2      Generating the Output Design Reports
    2.5 Viewing and Interpreting the Output Design Reports
    2.6 Printing the Output Design Elements
    2.7 Printing and Storing the Input Design Elements
    2.8 Exporting the Input Design Elements and Generated Physical Schema

  3      Tuning the Database Environment
    3.1 Collecting System Data for Tuning
      3.1.1      Collection Logical Names
      3.1.2      When to Collect Tuning Information
      3.1.3      Where to Collect Tuning Information
      3.1.4      What Data to Collect
      3.1.5      Starting Data Collection
      3.1.6      Stopping Data Collection
    3.2 Importing Tuning Data
    3.3 Generating Tuning Recommendations
    3.4 Generating Tuning Reports
      3.4.1      Tuning Audit Report
      3.4.2      Tuning Analysis Report
      3.4.3      Tuning Configuration Report
    3.5 Implementing Tuning Recommendations
      3.5.1      Changing User Quotas
      3.5.2      Changing System Parameters
      3.5.3      Changing the Database