Hi, I am going to launch a site with nearly 400 dynamic pages, all the development is done, we are generation each page through the database with procedures. So please let me know the tuning techniques, as well as the deployment precations.
Till now the databas is developed on LINUX plat form, now the deployment is going to be changed to the Solries.
S, I want to know the precations need to take when deploying the database on solaries platform. I am going to use
UMX -50 processor,
and 1 GB hard disk.
I am not much aware much about the dba concepts. Please help me in fine tuning also.
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.