Sonia,
Depends first on how many different sessions you have (if this is
done by a single batch program no need to worry - at least about
INITRANS) and on whether the updates affect rows in the same blocks or
not. For inserts, you'd be better off by increasing the number of free
lists (to distribute inserts to different blocks and decrease
contention). For updates, if the rows you update do not share the same
blocks, no need to worry for tables. However, if you update indexed
columns, it may be wise to increase INITRANS a wee bit for those
indexes, since indexes are more 'compact' than table and there is an
increased risk of two sessions hitting the same block. Check V$WAITSTAT
and do not forget you may have contention on rollback segments too -
don't forget them.
--
HTH,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> Our client has a table which will have over 200
> updates and 100 inserts every second. Should I leave
> the default setting for inittrans or should I increase
> the value of this parameter. Can someone shed some
> light on this issue.
Received on Mon Nov 06 2000 - 10:03:14 CST
