I have a question concerning performance that is related to the number of oracle instances that are running on a platform. For example, I have 5 applications (systems) such as accounting, manufacturing, etc that have been implemented in oracle. Each application is comprised of at least 30 tables. The total database is over 5 gigabytes. The machine is a sequent running unix and has 8 CPUs. We are thinking of switching to 5 databases with 5 oracle instances (each application has its own instance/database/CPU). Since oracle is architected to run on a machine with multi- processors, this should increase performance. Has anyone actually done this? What were the problems that were encountered? What are some advantages and disadvantages of this technique. Thank you for your time. Damian Yenzi (uunet!melpar!yenzi) E-Systems Dba Received on Thu May 20 1993 - 00:12:49 CEST
Damian Yenzi (uunet!melpar!yenzi) E-Systems
Original text of this message