[HPADM] Unix_Oracle Migration

Paul.Soltermann_at_vonroll-isola.com
Date: 08/11/03

  • Next message: Binkley Robert - rbinkl: "[HPADM] information .SH_HISTORY"
    To: hpux-admin@dutchworks.nl
    Date: Mon, 11 Aug 2003 11:19:55 +0100
    
    

    Hallo admins,
    We are going to run our ERP-System on a System HP rp5470-750MHz-2
    2x 750 MHz, 2 x 2GB memory , 2x73GB harddisk drives
    OS HP-UX 11.00 (64bit)
    The application software is BPCS-ERP System.

    We intend to install 3 different ORACLE8.1.7(32bit) Databases:
    1 DB 12 MB 120 users
    1 DB 6 MB 20 users
    1 DB 6 MB 3 users

    My questions:
    1) What is better to install:
        3 Instances with 1 DB User
         or
        1 Instance with 3 DB Users (with different set of tables) ?

    2) What are the optimal values for shared memory ?
    3) What is the optimal value for ORACLE shared_pool_size (120MB)?
    4) ORACLE-Datafiles: What is better for performance:
         8 x 1024 MB
         or
         4 x 2048 MB
                                       
     Thanks for all suggestions !
                                       
                                       
       Schweizerische Isola-Werke AG
              Paul Soltermann
            Passwangstrasse 20
            CH-4226 Breitenbach
      Phone: +41 61 785 56 47 Natel
                079 4597835
                  Email:
     paul.soltermann@vonroll-isola.com
                                       

    --
                 ---> Please post QUESTIONS and SUMMARIES only!! <---
            To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
           Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
     
     Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
                http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)
    

  • Next message: Binkley Robert - rbinkl: "[HPADM] information .SH_HISTORY"