Alex,
We've done both. Is there a down side, yes on both counts.
With multiple Peoplesoft schema's your tablespaces need to be bigger, like
initial size times number of schema's plus fudge factor. Also you can get IO
bound on certain tablespaces, like PSINDEX real fast. You really can't have
separate tablespaces for each schema without doing a LOT of work. You can have
separate index tablespaces without too much work though.
With multiple instances your system, redo, temp, etc.. disk consumption
rises by the number of instances, semaphores and semaphore sets need
maintenance, memory needs rise more than you'd believe, and system response time
in general drops radically. It's a lot more pain with upgrades, patches, etc.
since db links really run between instances instead of doing a loopback
(Peoplesoft also ships a synonym script incase you go the non multiple instance
route which really works better).
Which way do you want to go, depends on your needs and resources.
PeopleSoft developers and the like will buck you on having multiple schema's in
one instance which I blame on PeopleSoft training, it's bad on this subject.
I'd recommend a separate instance for Production and QA/TEST. Development, Demo
and AUD can easily reside in the same instance.
Dick Goulet
____________________Reply Separator____________________
Author: "Hillman; Alex" <[EMAIL PROTECTED]>
Date: 3/28/2001 6:35 AM
Can anybody give me pro and con for having let say several Peoplesoft
schemas in the same database versus in different databases. Should objects
of different schemas be in the same tablespaces or every schema should have
it's own set of tablespaces etc.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
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).
