Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to tune insert opreation performance?

Re: How to tune insert opreation performance?

From: Access <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 22 Dec 2004 16:54:24 +0100
Message-ID: <41c998b3$0$29516$ba620e4c@news.skynet.be>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US