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>



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-l
Received on Thu Nov 30 2017 - 23:25:36 CET

Original text of this message