Setting up the initial configuration for a database

I am planning to create my database in Oracle 9i. I have an estimated 6 GB of data, and on average, my database...

may see increases of 500 MB. Could you help me in the initial configuration? I have twelve systems connecting to my server, and the client application is installed, with an average of 18,000-20,000 transactions/day.

1. SGA_MAX_SIZE
2. LOG_BUFFERS
3. control_files I am planning to multiplex to three different disks, since I have three disks
4. log files on three different disks
5. My database is in archivelog mode
6. I want to have this system on a shared server, so what should I do: just write SHARED in tnsnames.ora or anything more?
7. What should the db_cache_size be?
8. db_keep_cache_size
9. db_recycle_size
10. What should be my db_files

It is hard to determine exactly how you should size your database, even given the information that you have. A 6 GB database isn't too big. But more than just the size, and the number of concurrent connections, you need to take into account *how* your data will be used. Here are some guidelines that I can offer.

1. Start by using the MEDIUM size parameters specified in the default INIT.ORA. This is a good start.
2. You'll want to monitor database performance to see if any INIT.ORA parameters need to be changed for better performance.
3. Make sure that you multiplex your control files to three different disk volumes.
4. Make sure you spread out your online redo log files. And make your ARCHIVE_LOG_DEST on a different volume from any archived redo log.

For More Information

• Dozens more answers to tough Oracle questions from Brian Peasland are available.
• The Best Oracle Web Links: tips, tutorials, scripts, and more.
• Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.