Re: How to tune insert opreation performance?

"Michael" <michael.lohmar_at_gmail.com> wrote in message news:1103721310.598627.305450_at_f14g2000cwb.googlegroups.com...
>
> Hello Pankej,
>
> > how to tune the insert opreation performance...
>
> Hm ... Where is your problem with your insert operations?
>
> In general it depend on the count of indices you have created on your
> table, trigger which are maybe fired during the insert, a bad space
> management for this table and/or what is often a problem ... on a wrong
> setting of the inittrans value for this table. Many time a slow insert
> operation is forced due to concurrent inserts which do block each
> other. Not to forget I/O bottlenecks of the system and concurrent
> read/writes on the same disk.
>
> As you can see there are a lot of reasons and I'm sure I forgot about
> to mention a few in my list ...
> Maybe you should ask a little bit more concrete.
>
> Greetings,
> Michael
>

Considering INITRANS : I always wondered why the default value = 1 ? Are there any disadvantages in setting it for example to 10 for all tables/indices ?

Matthias Received on Wed Dec 22 2004 - 09:54:24 CST