CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      Overview

  2      Merging and Formatting Data Collection Files
    2.1 Merging and Formatting Collected Data into an Oracle Rdb Database
    2.2 How to Optimize Formatting for Oracle Rdb Databases
    2.3 Merging and Formatting Collected Data into a VAX RMS File

  3      Producing Standard Oracle Trace Reports
    3.1 Report Index Pages
    3.2 Using REPORT Qualifiers to Change Report Content and Organization
      3.2.1      Joining Items Between Events and Facilities
      3.2.2      Reporting on Individual Event Occurrences
    3.3 Summary Report
      3.3.1      Specifying the Kinds of Statistics to Report
    3.4 How Oracle Trace Reports on Duration Events
      3.4.1      Limiting Items in a Report
      3.4.2      Connecting Events by Shared Item Values Using /JOIN
      3.4.3      Displaying All Occurrences of an Event Using /GROUP_BY
    3.5 Detail Report
    3.6 Frequency Report
    3.7 How Oracle Trace Wraps Text in Reports

  4      Producing Customized Oracle Trace Reports
    4.1 Keywords to the /OPTIONS Qualifier
    4.2 Using the /OPTIONS Qualifier
    4.3 Example of a Customized Report
    4.4 Connecting Events Using the JOIN Keyword

  5      Optimizing the Report Process
    5.1 How to Optimize Reporting from Large Formatted Databases
    5.2 Optimizing Reports That Use the /JOIN Qualifier
    5.3 Defining an Index

  6      Troubleshooting Oracle Trace Reports
    6.1 Field Width Too Small for Value
    6.2 Problems with Reports Using JOIN

  7      Oracle Trace Formatting and Reporting Commands

  @ (Execute Procedure)

  FORMAT

  HELP

  REPORT

  REPORT Options-EVENT

  REPORT Options-ITEM

  REPORT Options-JOIN

  REPORT Options-RESTRICTION

  A Oracle Rdb Database Format
    A.1 The Data Types
    A.2 String Data Segmentation
    A.3 Relations for the Control Information
      A.3.1      The EPC$IDENT Relation
      A.3.2      The EPC$SELECTION Relation
      A.3.3      The EPC$COLLECTION Relation
      A.3.4      The EPC$DCF Relation
      A.3.5      The EPC$REG Relation
      A.3.6      The EPC$FACILITY Relation
      A.3.7      The EPC$EVENT Relation
      A.3.8      The EPC$ITEM Relation
      A.3.9      The EPC$EVENT_ITEM Record
      A.3.10    The EPC$PROCESS Relation
      A.3.11    The EPC$IMAGE Relation
      A.3.12    The EPC$DCF_IMAGE Relation
      A.3.13    The EPC$FACILITY_IMAGE Relation
      A.3.14    The EPC$RELATIONSHIP_TABLE_NAMES Relation
    A.4 Relations for the Collected Data
    A.5 The Entity Relationship Diagram for the Database
    A.6 The Predefined Views
      A.6.1      Relating Collection Information with Event Data
      A.6.2      Relating Selection and Collection Information with Event Data
      A.6.3      Relating Image Information with Event Data
      A.6.4      Relating Process and Image Information with Event Data
      A.6.5      Limitations

  B VAX RMS File Format
    B.1 Data Types
      B.1.1     Date
      B.1.2     Fixed ASCIC/ASCIW String
    B.2 Records Organization
      B.2.1     Control Records
        B.2.1.1      FMTDICT Record
        B.2.1.2      COLLECTION Record
        B.2.1.3      FACILITY Record
        B.2.1.4      DCF Record
        B.2.1.5      IMAGE Record
        B.2.1.6      FACILITY-REGISTRATION Record
        B.2.1.7      EVENT Record
        B.2.1.8      Item Descriptor
    B.3 Data Collection Records