File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Can I use Oracle in this situation ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Can I use Oracle in this situation ?" Watch "Can I use Oracle in this situation ?" New topic

Can I use Oracle in this situation ?

Hussein Baghdadi
clojure forum advocate

Joined: Nov 08, 2003
Posts: 3479

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 ?
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

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.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Nicolas Stern
Ranch Hand

Joined: Apr 26, 2002
Posts: 57

Effectively, you will need more memory.

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.
I agree. Here's the link:
subject: Can I use Oracle in this situation ?
It's not a secret anymore!