wait in concurrent insert in a table
HesipesiDec 25 2008 — edited Dec 27 2008I have a serious problem in my database which significantly increase concurrency .
It leads to long-time waits and force me to kill some sessions.
I have a table (KP...) in a specific time of day there is up to 4 concurrent heavy insert in this
table.
what is the possibilities in improving the performance of this table ?
How can i reduce this kind of wait events?
thank you in advance