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