Ben,
In addition to Dennis' comments, I would add that using a separate
tablespace for
each user doesn't make much sense to me.
What is the perceived benefit of this?
Oracle will accomodate a large number of users and objects without
putting each in their own tablespace. This seems like it would just
create a lot of extra work for you.
An extreme number of database files can have an adverse affect
on performance as well.
Jared
"Ben Poels" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/06/02 11:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Hundreds of schemas in one instance?
Hi
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: [EMAIL PROTECTED]
======================================================================
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ben Poels
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
