Re: Oracle 8 Problems

This is a typical case of a way too small and inadequate server. Twenty databases on one server, you must be joking. For one database you already need 128M, let alone for 20. Following the Oracle guideline a max of one third of memory is allocated to SGA, you have some 40M SGA, you should have much more, or the SGA of your individual databases is too small. Equip that one server with 372 Mb extra, buy 3 more servers with the same amount of RAM -they are not that expensive- and reconfigure!

Hth,

--
Sybrand Bakker, Oracle DBA
<bm_lindsey_at_my-deja.com> wrote in message news:85l5on$bbb$1_at_nnrp1.deja.com...
> Wondering if anyone else has had real flakey things happening with
> their Oracle 8 installation. We are running Oracle 8.0.5 with 20
> databases, all created with the database wizard and specified as
> small. The hardware is a dual celeron 500 with 128MB ram and is
> running NT 4 with service pack 5. This is the machine's only purpose
> and only has a couple people on it at a time.
>
> Has anyone run up against a limit of the number of databases you can
> have attached to one Oracle database instance? Any other ideas?
>
> We had a similar setup in Oracle 7.1 running on a Pentium Pro 200 with
> 96MB ram.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 13 2000 - 12:50:04 CST