Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Hard numbers for INITRANS and MAXTRANS
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