Re: weird insert behaviour
From: GG <grzegorzof_at_interia.pl>
Date: Tue, 07 Feb 2012 11:27:17 +0100
Message-ID: <4F30FC85.5020806_at_interia.pl>
W dniu 2012-02-07 10:57, Remigiusz Sokolowski pisze:
> Hi,
>
> db 11.2.0.2.4 on aix
>
> through the code we make a few hundreds thousands of inserts into a
> large partitioned table.
> It takes some time, but usually it is a stable process (ie. time is more
> or less predictable).
>
Maybe this bug/feature :
INSERT slow on ASSM [ID 1263496.1]
Date: Tue, 07 Feb 2012 11:27:17 +0100
Message-ID: <4F30FC85.5020806_at_interia.pl>
W dniu 2012-02-07 10:57, Remigiusz Sokolowski pisze:
> Hi,
>
> db 11.2.0.2.4 on aix
>
> through the code we make a few hundreds thousands of inserts into a
> large partitioned table.
> It takes some time, but usually it is a stable process (ie. time is more
> or less predictable).
>
Maybe this bug/feature :
INSERT slow on ASSM [ID 1263496.1]
If You are using ASSM :) but who doesnt :) . Anyway, next time few process stack dumps would help find out where we stuck (ASSM related calls) .
Regards
GG
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 07 2012 - 04:27:17 CST