Hi.

I've got Oracle9i Release II running on an old laptop. I used a 4M for the shared pool and the buffer cache. You can definitely reduce the size of the redo logs. Try 1M to start with. The undo tablespace can be below 100M provided you're not doing loads of work requiring undo. Also, the system tablespace can drop down to about 70M provided you don't pick all the optional features.

To get a script, start the Database Configuration Assistant and pick a custom install. Reduce the size of all the files to values you find acceptable. Remember to uncheck all the extra features or your system tablespace will end up at about 260M. At the end of this process choose to save the creation scripts rather than run them immediately. You then have a set of scripts you can adjust as you wish.

Some of the extra options require quite a bit of memory to load. If you pick these you will need to allocate quite a bit of memory to the shared pool, large pool and java pool.

Cheers