John M wrote:
> Hello,
>
> I have to test a web application with ORACLE DB on my PC.
> The database is in test phase, so it has got only 15 tables and all tables
> contains only 10-30 records.
> I use Oracle 8i. After install my system use about 320MB RAM after startup.
> How can I configure Oracle to minimize hardware requirements?
> I know I have to change the init.ora file but what can be the minimal values
> for the parameters? Is it any other minimizing possibility?
> (I must use Oracle 8i, JDeveloper 9.0.3, Windows 2000 on the same PC
> /Pentium III 650MHz and 256Mb RAM/).
>
> Thanks!
>
>
>
Reduce shared_pool, db_block_buffers (and other buffers)
That should do a lot.
Disable Java in the database (and remove the Java pool from
init.ora) if you don't need it. Diable the large_pool; it's
value is ridiculous by default anyway
--
Regards, Frank van Bortel
Received on Mon May 19 2003 - 14:33:54 CDT
