I expect the following question has no single optimal answer, so I
look forward to learning various points of view.
How should I decide where to implement the schema for a new purchased
application?
Assumptions:
- This is a generic question
(ie, I have more than one application to consider).
- Some Oracle servers and instances already exist.
- All Oracle servers are UNIX.
- The existing Oracle servers are not "maxed out".
- It may be possible to add resources (RAM, DASD, or CPUs)
to the existing Oracle servers.
- While server resources cannot be ignored,
resources are not the primary focus of my question.
- Schema vary in size (from 5 tables to several thousand).
- Some applications require the schema owner to have DBA
privileges.
- Expenditures require a lot of justification.
With that in mind, how should I decide whether to recommend:
- Use an existing instance.
- Create an additional instance on an existing Oracle DB server.
- Create a new Oracle DB server and instance.
The options above are listed in the presumed order of preference.
In other words,
don't select option 2 unless option 1 would be a poor choice.
Why select option 2 (new instance) instead of option 1 (existing
instance)?
Some that come to mind are:
- instance uptime requirements (eg, the new application requires
more uptime than the existing instance can deliver).
- timing of Oracle version upgrades (eg, we want to upgrade the
instance to Oracle 9i2 for the benefit of application 1, but
application 2 is not yet certified for Oracle 9i2).
- DBA privs (eg, application 1 requires DBA privileges for the
schema owner, but application 2 contains sensitive data that should
not be available to the people who must know the application 1 schema
password)
Why select option 3 (new server) instead of option 2 (new instance)?
Some that come to mind are:
- server uptime requirements (eg, the new application requires more
uptime than the existing server can deliver).
- inadequate server resources on the existing server
..Rick
Received on Wed Apr 09 2003 - 18:57:31 CDT
