We are in a same boat, here is how I have deployed my Web databases:

Two main things with Web databases

I - Sub second performance
II - Security

For I - sub second perfomance consider following:

1) Carefully set init.ora parameters

Allocate proper SGA depending on your internal memory availibility, swap and database usage. Particularly pay attention to database block size, shared_pool_size (library_cache,dictionary_cache), large_pool and java_pool.

Set your frequently called tables in keep_buffer_pool.

2) Database design

Have a sound database design with focus on OFA standards, Storage parameters, tuned SQL and PL/SQL code, table partitioning, use of IOT, bitmap indexes and related stuff, but use the new feature only if you are 100% convienced about advantage of the feature.

3) Careful usage of connection pool and multi threading.

II - security

1) Use appropriate level of security as per your organization standards. Be careful about using single schema multiple
session connection scenario.


Hope this helps,

For more information browse http://www.tusc.com's download area.