setting up correct values for parameters within Ora_ini file

[dps]

Hello.

I have just installed Oracle personal edition 8.1.7. What I wish to know is that what sort of values should I 'ideally' have set up for the parameters and which ones need concern me. Since I have installed oracle my machine processing times for applications have slowed tremendously..

Can anyone help?

Thanks in advance.

 

[Turkbear]

Hi, A review of the concepts docs ( and the administration ones as well) at

http://tahiti.oracle.com

will help..

It all depends on what you are using Oracle to do..

In the sample init.ora file there are small,medium and large configurations - use all the small ones and see how it goes...
Pay close attention to the 'large_pool_size' and 'java_pool_size' - if you are not using Java in the Database you can set them to 0 bytes...