Hey all. I want to try an evaluation verion of Oracle 9i database. I just want to try the Personal edition , but AFAIK , Oracle requires at least 360 MB of RAM to work (Oracle residents in RAM -at least 360 MB- and requires more to run). the problem is my RAM is just 192 MB (ofcourse, not the all space is available because I run eclipse also in addition to JBoss or RI). is there an option during installing Oracle (or after) that prohibit Oracle from occupaying the RAM ?
Oracle is a big, complex application. And it uses a Java installer to install itself, which is slow and memory/CPU hungry. There's no getting round this. Trust me if you are going to use it you'll be far happier with a lot more RAM than 192MB. Luckily memory is pretty cheap these days.
It is possible to configure your oracle server to be less hungry after installation. Look in the initialization parameters for the shared pool, buffer pool and Java pool parameters. It is a bit tricky to configure.