Re:RE: What is best practice - differenet schema/different d

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" <MLanteigne_at_edc-see.ca>
Date:       3/28/2001 9:45 AM

Actually I meant Dick, nor Doug, sorry

Mike

> -----Original Message-----
> From: Lanteigne, Mike [SMTP:MLanteigne_at_edc-see.ca]
> 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: dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
> > 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: MLanteigne_at_edc-see.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lanteigne, Mike
  INET: MLanteigne_at_edc-see.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

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).