-
Hi,
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.
Hope this helps,
For more information browse http://www.tusc.com's download area.
-
Set your frequently called tables in keep_buffer_pool.
It is buffer_pool_keep, not keep_buffer_pool.
-
I think, being a DBA one can easily find out exact names of parameters.
Personally, I don't try to remeber the extact name of the parameter but prefer to always refer to version-related latest documentation, as Oracle keeps changing names or dropping and adding some.
Hope this helps.
-
Hi,
Thank you both prafful, and julian for your replies.
I got some help , once again many thanks,
regards,
khaleel
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|