Mike, If that's the worst you guys/gals call me I'll be extremely flattered. Over the years I've had names tossed at me that are not normally usable in impolite society! :-) Dick Goulet ____________________Reply Separator____________________ Author: "Lanteigne; Mike" <[EMAIL PROTECTED]> Date: 3/28/2001 9:45 AM Actually I meant Dick, nor Doug, sorry Mike > -----Original Message----- > From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, March 28, 2001 8:35 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: What is best practice - differenet schema/different dbs > > Hi Doug , (and all) , > > Just curious - the PS environment, do you put finance and HR on the same > DB? > Do you share the sysadm user? I'm new to this PS stuff, so this interests > me. Also, in production, do you have the PS databases separated from the > other OLTP databases? > > Thanks > > Mike Lanteigne > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, March 27, 2001 12:56 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:What is best practice - differenet schema/different dbs > > > > Rao, > > > > I'm going to differ from a previous return post. I think that you > > should > > use different schema's with separate tablespaces. Why? Because your > all > > on one > > machine therefore all of your background Oracle processes are competing > > for the > > same CPU, memory, and IO resources which can and does slow matters down > > significantly. The best bet in my experience is one large DB instance > > with a > > very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried > > both > > approaches with our PeopleSoft development environments and this works > > much > > better than multiple instances. Way too much background CPU & Memory > burn > > not > > to mention all of the wasted disk space for multiple system, temp, rbs, > > and > > other tablespaces. It really dings the IO too. BTW: with each schema > in > > it's > > own tablespace(s) you can still take one offline without crashing the > > others, > > unless you need to take system or rbs offline. > > > > Dick Goulet > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Lanteigne, Mike > 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: Lanteigne, Mike 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).