Oracle DB Install Parameters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle DB Install Parameters

  1. #1
    Join Date
    Feb 2002
    Posts
    23
    Hi All,

    I need to set up a database on Solaris.
    The hardware set up is like this, Server capacity is 216GB(12disks of 18 GB each), 1(one) disk controller and has RAID 5. Its with 4GB RAM and 4 CPU.
    The database size starts with 20GB and is expected to grow up to 100GB by the end of the year. We have around 300 tables. Our application is an OLTP and we are planning to create DB in MTS mode.

    1) Which are the parameters which should be compulsorily changed from the default settings.

    2) Any thumb rule or equations are there to decide the values for these parameters ?. If any pls mention.

    Louis.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Make sure you set the semaphores enough to handle the load. The rest of the tuning is an on going process.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2001
    Posts
    64
    and Don't forget share mem, see oracle install docs for setting.

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