Oracle7 / Performance

Currently, we are installing Oracle on a IBM RS/6000.

Environment: RS/6000 Mod. 570, AIX 3.2, 384 MB main storage, 10 GB online storage, Oracle RDBMS V 7.0.12, SQL*Forms 3.0, PL/SQL, SQL*Reportwriter.

The application will put heavy load on the database. Generally speaking, there are two classes of programs: programs which require immediate response to the user (in less than a second), and others where response time is not a primary factor.

What can I do to give "priority" to the programs requiring immediate response ? I thought of setting up two separate instances of the same database with different prioritys, and then connecting to the different instances depending on the program to run. Is this the right way ? Have anyone tried this ? Are there other ways to do this ?

Any comments are welcome.

Willy

--


======================================================================

Willys Mail     FidoNet   2:2407/46    Mail Only System
                GlobalNet 52:4907/4    USR Courier HST dual standard
                CIS: 100020,3517
                willyk_at_kbigate.novalis.public.sub.org


======================================================================