Conference ulysse::rdb_vms_competition

155.0. "Oracle sizing, VMS 5.0, INFO/HELP " by KCDEMO::DUNCAN (Gerry Duncan @KCO) Wed Jul 06 1988 01:19

    Last Friday I participated in a conference call between our customer
    and an Oracle "sales support" technician in Denver.  Highlights
    from the Oracle person:
    
    - Oracle 5.1 DOES use the VMS lock manager in a cluster
    - Oracle 5.1 DOES run "just fine" under VMS 5.0 
    - Oracle 5.1 DOES run "just fine" on a multiprocessor system (62xx)
       but has not been modified for parallel processing

    SIZING INFORMATION
    ------------------
    The Oracle person instructed me to use the following factors for
    our configuration:
    
    - Once table size is determined, multiply it by 2 for disk requirement
    - AIJ causes a 20% performance hit 
    - In a cluster environment, Oracle (and VMS cluster overhead) causes
       a 20% performance hit
    - For SQL*net operations, use 50% throughput over Ethernet.
    - In at interactive environment using SQL*forms, they recommend
       using 1 MIP (whatever that is) for 10 users.
    - Use VMS backup for the database. No "incremental" method
    - Use 1MB memory per Oracle user
    - Figure 3mb for the Oracle runtime, buffer areas, and kernel

    This notes file indicates that some of what the Oracle told me and
    his customer is not true (eg lock mgr, clusters).  I need to know
    if any of you have knowledge "beyond a shadow of a doubt" that says
    Oracle WILL NOT run on a cluster, VMS 5.0, or a 62xx/88xx system.  
    
    Please let me hear from you and, more importantly, give me the words to
    say so I can pin this Oracle slime to the wall.
    
    Thx ...  Gerry Duncan @KCO DTN 452-6287