Oracle-L: Hundreds of schemas in one instance?

From: Ben Poels <poelsb_at_post.queensu.ca>
Date: Wed, 06 Mar 2002 11:28:40 -0800
Message-ID: <F001.004211B4.20020306112840@fatcity.com>

Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user.

Some of the pros for this are:
- easy set up for new users

easy software upgrades
simplified tuning, backups, monitoring, auditing
user isolation, especially disk space usage
multiple instances would use far more memory

Some cons are:
- everyone must use the same release of the software

database down time affects everyone
might run into system maximums, for example max. number of datafiles
an enormous SYSTEM tablespace

Has anyone had to this kind of thing? Any comments or suggestions?

TIA, Ben

Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: poelsb_at_post.queensu.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ben Poels
  INET: poelsb_at_post.queensu.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Mar 06 2002 - 13:28:40 CST