Q
Problem solve Get help with specific problems with your technologies, process and projects.

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
I also need to implement some security. What things should I take into account?

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.
In the end, you need to do "Database Administration" on this database. This is a very long topic. Might I suggest getting a copy of Oracle 9i DBA Handbook by Loney on Oracle Press. It covers lots of details.

For More Information


This was last published in February 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close