| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:several peoplesoft databases (schemas) in one Oracle data
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" <Alex.Hillman_at_usmint.treas.gov> 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: Alex.Hillman_at_usmint.treas.gov
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).
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 28 2001 - 11:15:52 CST
 |
 |