Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Hard numbers for INITRANS and MAXTRANS

Hard numbers for INITRANS and MAXTRANS

From: <vasarpota_at_my-deja.com>
Date: 2000/08/01
Message-ID: <8m6l4n$qil$1@nnrp1.deja.com>#1/1

I understand that INITTRANS and MAXTRANS should be set object by object. Ia also understand that the number are determined by the size of the object and the concurrency for the object. But what hard values are reccomended?

I am also assuming that indexes have a higher INITRANS and MAXTRANS than data segments.

Do you usually put INITRANS=MAXTRNAS for the more static tables? Is it good practive to always keep the two equal?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US