Q: impact of freelists on inserting ?

From: <tedchyn_at_yahoo.com>
Date: Thu, 21 Oct 1999 23:14:54 GMT
Message-ID: <7uo6pb$qjl$1@nnrp1.deja.com>

Sir, I have following waitstat in one heavy inserting instance. when I increase dbwr from 1 to 4. waitstat number did not change very much. I found out freelists on table was setup to 10. generally you set freelists to > 1 (may be 2) for heavy inserting table. my question is what kind negative impact high freelists has on a table aside from more storage requirements ?

thanks in advance Ted

CLASS                   COUNT       TIME
------------------ ---------- ----------
data block             350262     231895
sort block                  0          0
save undo block             0          0
segment header           5701      16139

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 18:14:54 CDT