Re: Simple Insert tuning
From: dba Wilson <iamanoracledba_at_gmail.com>
Date: Fri, 1 Dec 2017 09:25:36 +1100
Message-ID: <CAJmRzAcnvedj5U84shjpNWNUJYw4t1FKKFJLO2ru4pNpdEStWw_at_mail.gmail.com>
Date: Fri, 1 Dec 2017 09:25:36 +1100
Message-ID: <CAJmRzAcnvedj5U84shjpNWNUJYw4t1FKKFJLO2ru4pNpdEStWw_at_mail.gmail.com>
Hi Sanjay,
You can do a 10046 trace. Sometimes it might be caused by recursive calls, like triger.
Regards,
Wei
2017-12-01 8:33 GMT+11:00 Sanjay Mishra <dmarc-noreply_at_freelists.org>:
> Hi everyone
>
> Need to know what factors can cause slowness for simple insert into a
> table. while executing the plan it is showing Load Table conventional
> operation but had big difference in the Cost in Dev vs Test. Both
> environment has same data refreshed from Production.
>
> Does Column Stat can make this difference like sample size while
> collecting the data or any other advice.
>
> TIA
> Sanjay
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 30 2017 - 23:25:36 CET