[HPADM] Unix_Oracle Migration

From: Paul.Soltermann@vonroll-isola.com
Date: Mon Aug 11 2003 - 06:19:55 EDT


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)


This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:32 EDT