Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimal Initialization Parameters
For my classes at the University of Washington I run as follows:
IBM Thinkpad (300MHz) with 64MB RAM. I have Oracle 8.1.7 installed, up and running, and routinely also run SQL Navigator, SQL*Plus, and Oracle Developer Forms and/or Reports 6i (ALL AT THE SAME TIME). I have yet to run out of memory. An Oracle instance can be very lean.
For informational purposes ... from the init.ora
db_block_size = 8192 db_file_multiblock_read_count = 8 db_block_buffers = 2048
Daniel Morgan
Sybrand Bakker wrote:
> On Fri, 11 Jan 2002 15:41:32 -0800, "Jack Dawson" <srik_at_cnet.com>
> wrote:
>
> >Isn't 160 MB no good? Oracle Docs say 128 MB is good enough!!!! I am talking
> >about 8.1.6 database and not 9i
> >
> >
>
> 128 M is the bare minimum. They specify it just the way Microsoft
> does. In quite a few situations NT alone consumes 128 M. Your database
> will simply crawl. 256 Mb is nice with a SGA of about 40-60 M, however
> all applications nowadays need more (as most developers stopped
> thinking about optimal design). If I see a server with *only* 256 M,
> especially if it is used to run a webserver against it, I will always
> recommend to have memory at least doubled.
> Memory is not that expensive you know, or you must be still running a
> P133.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Jan 12 2002 - 06:16:14 CST