Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.frii.net!newsfeed.frii.net!news-out.newsfeeds.com!propagator2-maxim!propagator3-maxim!news-in.superfeed.net!news.mccons.net!news.maxbaud.net!newssvr31.news.prodigy.com!newsdbm02.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr16.news.prodigy.com.POSTED!34d3422d!not-for-mail
From: Karsten Farrell <kfarrell@belgariad.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: The right 
Message-ID: <MPG.194a5dc46ab0a9889897b6@news.la.sbcglobal.net>
References: <3ee075b7$0$4098$4d4ebb8e@businessnews.de.uu.net>
X-Newsreader: MicroPlanet Gravity v2.60
Lines: 19
NNTP-Posting-Host: 67.117.210.172
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr16.news.prodigy.com 1054916073 ST000 67.117.210.172 (Fri, 06 Jun 2003 12:14:33 EDT)
NNTP-Posting-Date: Fri, 06 Jun 2003 12:14:33 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: TSU[@I_A\S@KBUT^AZNX_T\BUSXB@DTMNHWB_EYLJZ]BGIELK^RAQFW[ML\THRCKV^GGZKJMGV^^_JSCFFUA_QXFGVSCYRPILH]TRVKC^LSN@DX_HCAFX__@J\DAJBVMY\ZWZCZLPA^MVH_P@\\EOMW\YSXHG__IJQY_@M[A[[AXQ_XDSTAR]\PG]NVAQUVM
Date: Fri, 06 Jun 2003 16:14:33 GMT
Xref: core-easynews comp.databases.oracle.server:189051
X-Received-Date: Sun, 08 Jun 2003 12:40:23 MST (news.easynews.com)

sabrina.kretzler@gillardon.de said...
> Hi everybody,
> 
> I have a oracle 8 and 9 server and would like to configuration the data base
> memory (Shared Pool, Buffer-Cache, Large Pool, Java-Pool) . I use this data
> base only for tests (not productive).
> 
> Which configuration do you recommend?
> 
> THANKS for your help
> Sabrina
> 
There is no right answer to your question. If you only use it for 
testing, then I'd suggest leaving everything at its default value. Then 
if you run into problems later, adjust whichever parameter will help 
resolve the issue. I would never offer this advice for a production db.
-- 
/Karsten
DBA > retired > DBA