What’s the smallest Oracle instance possible?
Unfortunately, my first postings on jdeveloper 10g have mostly discussed it’s memory usage. That’s a bit unfair, as it is a nice IDE. I’ve installed it on another laptop, with 512Mb. My previous laptop had 384Mb and a lot of company installed management software. On this new clean laptop, jdeveloper runs ok. No big memory issues. Ok, it still uses around 200Mb, but it is very useable. I can run Jdeveloper, OC4J (oracle’s j2ee server), and oracle 9i r2 at the sametime.
I’ve installed Oracle 9iR2 (the database), created a default database, and changed the memory settings (block buffers low, no java pool, etc). It now uses 80Mb. Is this as small as it gets, or is it possible to configure it to use even less memory?
27 Sep 2003 |
September 27th, 2003 at 11:42 pm
Talk about overkill for anything but a large database. MySQL uses just a couple megs. Much more light weight if you are going to use the same machine for both development and a database server.
September 28th, 2003 at 9:29 am
Not really an option. Mysql and Oracle and too different. MySql might be a good option for some applications, but if i’m going to use oracle in production, i also want to use Oracle in development and training. I’ve tried using jdeveloper with other databases, postgresql, firebird, oracle lite. Sometimes it’s doable, if you’re just using some tables. But i use a lot of pl/sql which is not supported on other databases.
November 19th, 2003 at 6:32 am
Have you successfully used JDeveloper Business Components with MySQL? I have the driver configured correctly as a Third-Party JDBC driver, and I can build the components. Running the components in the tester or a JClient results in the SELECTS working fine, but INSERT and UPDATE statements produce an error message stating that “Callable statments not supported”. Not sure why INSERTS and UPDATES would translate into a CallableStatement.
Have you encountered or found a workaround for this?
Thanks.