tuning database

How big is your SGA? With the numbers you show, I would expect it to be at least 160MB.

We run 300 processes on systems about the same size (HP not DEC) and get acceptable performances, but they only have about 1500 tables (plus indexes, etc......still about 1/3 your count, but the db is 500GB+)

Why 4 connections per user?

What are the users doing-if OLTP, then check the SQL, my first reaction is that you should be ok.) If OLAP, multiple instances won't help, because they are all still doing I/O.

In article <354FA9C8.3D598F12_at_compuserve.com>#1/1,   reinhard_bergander_at_compuserve.com wrote:
>
> We have a Alpha, 512 MB RAM, maximum of.30 Unix user with 4 DB
> connections per user. The system has one instance with more than 77000
> dba_objects!(16000 tables, 33000 indexes and 20000 views)
> With 10 user connected I have more than 300 unix processes! The
> application running is something like a terminal app.
>
> The whole system is very slow!
>
> I'm thinking about switching to multithreaded and splitting it up to
> multiple instances to reduce the system tablespace .(and of course
> upgrading the RAM)
>
> Anyone experiences or hints with a system like that??
>
> Thanx in advance,
>
> reinhard
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 06 1998 - 16:58:01 CDT