Re: Users on a single CPU (sparc)

Simong,

Not so good hardware to handle this kind of load. It is interesting how 512 Mb RAM could be sliced for Oracle 8i (probably) and 70 user sessions. They are not concurent most probably. Anyway, you will have performance issues if long running reports started in the same time most of those 70 users are doing OLTP.

Oracle 8i and upward have nice feature called Resource Managment where you can create resource groups and plans and assing users to them. It is designed just for case like that - daily OLTP and nightly batch jobs processing. Check it out.

IMHO I am skeptic about your hardware to be able to handle 70 concurent user sessions.

Check the latest Oracle DBA forums for more information, scripts, tips and tricks:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"simong" <xx_sg1_at_niks.demon.co.uk> wrote in message news:95a57eec.0205101758.5d6494e2_at_posting.google.com...
> Have I got any chance of running 70 users on a Sun Ultra 10 (500MB
> RAM, 300 MHz processor, UltraSCSI disc)? The database has several
> tables bigger than 300 MB, and is maybe 2GB in total (transaction
> processing, not 'datamart' - as you guys can probably work out fom the
> table sizes)
> Would it help if I banned users from running long reports - or won't
> this hardware even handle 70 users ?
>
> Thanks (hopefully)
>
> simong
Received on Fri May 10 2002 - 22:47:47 CDT