Re: performance question

From: Andre Allen <andre_at_interaccess.com>
Date: 1996/06/13
Message-ID: <4pnprg$3pm_at_nntp.interaccess.com>#1/1


In article <31BE4E51.342D_at_inetnebr.com>, terryr_at_inetnebr.com wrote: [Original Message Deleted]

Hi Terry

It is somewhat hard to figure why you may be having the 'burst' effect, especially since you have such a "manly" piece of hardware, but If my assumptions are correct, the initial "small, medium and large" init.ora file settings that Oracle includes is HARDLY enough for a production database. since at this point your tuning issues are limited to IO and Memory, there are a couple of things that you can try off the cuff, but there are dozens of factors that should be considered in order to get an accurate benchmark.

-How many rollback segments do you have, and how big are they?
-Are your indexes and tables on the same physical drive?
-What DB_BLOCK_SIZE was used when the database was created?
-What are the sizes of your Redo log files & redo log buffer?
-How often are your commits? (if committing at all)

a 'burst' effect may be becuase of IO contention between database writes, rollback segment writes and redo log writes. (possibly even archive redo log writes if you have archiving on) If these objects and their associated buffers are not sized correctly, the database comes to a 'grind' when it comes time to flush everything.


  • Andre T. Allen * andre_at_interaccess.com **
  • SysAdmin/DBA * 74262.3572_at_compuserve.com **
  • Reid Psychological Systems * 312.938.9200 (Voice) **
  • Chicago, IL * 312.294.0104 (Fax) **
Received on Thu Jun 13 1996 - 00:00:00 CEST

Original text of this message