Re: Tuning Oracle7 on Sun/Solaris

From: Tim Read - Sun Linlithgow Snr SE and DB Amb. <timr_at_cerrera.uk.sun.com>
Date: 23 Mar 1994 14:13:49 GMT
Message-ID: <2mpiqt$qlo_at_uk-usenet.uk.sun.com>


Best way to make an application is:

  1. Tune the DB design, use controlled redundancy where appropriate.
  2. Tune the application and SQL, use appropriate indexes, etc.
  3. Tune the i/o by striping the disks - you will need lots of small spindles to get the throughput. e.g 3GB data will probably need 6GB of disk or more and probably 12 spindles. This is true of applications like O*Financials, etc.
  4. Get lots of memory and don't let the system page.
  5. Tune the SGA to get as much data into cache as possible.
  6. Use 8k db_block_size.
  7. Make sure that you set the small_table_threshold right for the batch stuff.
  8. ... run out of ideas - that's more than three anyway :-)

Tim

---
Received on Wed Mar 23 1994 - 15:13:49 CET

Original text of this message