explain plan the sql statement, usually it is "merge.....", and you will see
what the problem is.
You might miss an index.
"Michael" <mikeeria_at_interia.pl> wrote in message
news:875e251b.0402110716.70105690_at_posting.google.com...
> Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:<5u7i201t0h5gvjm5vv6gsinnm9e8sumk11_at_4ax.com>...
> > On 10 Feb 2004 08:41:06 -0800, mikeeria_at_interia.pl (Michael) wrote:
> >
> > > sort_area_size = 104857600
> >
> > What strikes me you have a sort_area_size of 100M. My feeling says
> > there is something seriously wrong and your request is the result of
> > prolonged symptom fighting. I have never ever seen a sort_area_size of
> > 100M was necessary.
>
> I must admit db administration is not my game. I can argue with the
> DBA around this value but it doesn't make a difference. I tried by
> changing my session settings but the timings are still unacceptable.
>
> I noticed that DMBS_SNAPSHOT.refresh performs delete,insert instead of
> updates
> even if the updated fields are not primary keys. And these operations
> of delete,insert takes forever.
Received on Fri Aug 27 2004 - 16:42:31 CDT
