Re: Smallest possible instance.

Mark Leith wrote:
>
> Hello all,
>
> Does anybody know the smallest possible size (SGA etc.) that an instance can
> be, and still run and accept connections?
>
> We have a test laptop that will be running Oracle 8.1.7, along with some of
> our tools against it, so the instances only need to accept around 2-3
> connections..
>
> If you have a sample init file or something like that also, that would be
> great..
>
> Cheers
>
> Mark
>

Mark,

I had 8.1.7.0.2 running on a laptop (W2K Pro) with only 80 MB of RAM. I think that the SGA was around 48 MB total, with only 8 MB set aside for db_block_buffers.
Are you using Java? You can reclaim 20 MB by not using the default settings for java_pool_size.

I'd try to disable as many operating system services as you can - or at least set them to manual, so that they don't acquire resources at boot time.

I'd also create the database elsewhere (on a machine with more horsepower) and move it over to the laptop.

hth,

Paul

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).