Oracle architecture - any help would be preferred

Hello,

I am a beginner at Oracle administration and I would be grateful for any suggestions:
Target - Oracle9i database designed mainly for Web applications, 100-150 connections working concurrently (average value), max 300 connections. Operating System: SUN Solaris 8 with 4GB Ram.

Dedicated or MTS???;
memory size (shared and buffer cache) - I think, 100MB for shared memory size and 70 MB for cache size;
block size??;
3 control files (one of them on the different disk) 3 groups of log files (2 files in the group) Should I use undo management provided by Oracle9i?? How many space is needed for users' tablespace?? ...and any information, that could help me.

thanks
M. Received on Wed Aug 21 2002 - 09:20:32 CDT