I have a oltp environement with about 20 user inserting orders.
When there is more than 5 user concurently inserting orders, they complain about
time it takes to save the order.


SQL> SELECT * FROM V$WAITSTAT;

CLASS COUNT TIME
------------------ ---------- ----------
data block 5146 3703
sort block 0 0
save undo block 0 0
segment header 1 2
save undo header 0 0
free list 0 0
extent map 0 0
bitmap block 0 0
bitmap index block 0 0
unused 0 0
system undo header 0 0

CLASS COUNT TIME
------------------ ---------- ----------
system undo block 0 0
undo header 254 62
undo block 203 29


I have lots of wait on data block .
Presently, all the tables and indexes has a freelist of 5 and initrans of 5.

Do i need to increase freelist and initrans?
or just freelist?

Any more advice to give me?