Oracle database type

I am installing oracle 9i. There is a step asking for database type to be installed, they are:
-general purpose
-transaction processing
-datawarehouse

Which should i choose for my web application? Can anyone clarify for me the difference for each database type?

thanks.

Assuming you are a uni student...

General purpose for sure. Speaking from experience, nothing you'd have to do at uni would be outside the scope of "general purpose".

Chris

DBStudent is just a name that i used in this forum. But i am not a student, i am a developer.

Actually i just want the difference for this two option:
-general purpose
-transaction processing

I am developing a web application. What is meant by transaction in 'transaction processing'?

Let say i choose general purpose database type, then i use transaction demarcation in my application(java UserTransaction or CMP Bean), will this have effect to my application.

Or if this is the case, is that means i must use 'transaction processing' database type?

Thanks.

This selections influences the initial settings for things like the SGA, buffers, sort area size etc. Go with general purpose.

None of the settings will be carved in stone, you can change them later if you really feel like, and know what you are doing.

Transaction processing is aimed at installation which require several hundreds (if not thousands) of transactions per second. I doubt that you will reach that. But those installations would be hand-tuned anyway....

>>None of the settings will be carved in stone, you can
>>change them later if you really feel like, and know what
>>you are doing

This make me worry, how much effort will need if i configure it later and what is the effect of late-configuration to the application (what depedencies should i take care)?


Thanks.