What precations need to take when deploying the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What precations need to take when deploying the database

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Location
    Hyderabad
    Posts
    5

    Arrow

    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.

  2. #2
    Join Date
    Oct 2001
    Posts
    122

    Cool

    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.















  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Set your frequently called tables in keep_buffer_pool.
    It is buffer_pool_keep, not keep_buffer_pool.


  4. #4
    Join Date
    Oct 2001
    Posts
    122
    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.

  5. #5
    Join Date
    Sep 2001
    Location
    Hyderabad
    Posts
    5
    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
  •  


Click Here to Expand Forum to Full Width