Re: Simple Insert tuning

Hi,

Do you have any real time sql monitor to show us? This report will allow us to see the most consuming operation in the plan and the corresponding wait events. For example if the most consuming operation is load table conventional and you notice cpu and db file sequential reads wait event it's then possible that your query is spending most of its time on updating the existing indexes in the table specifically if those indexes have a very bad clustering factor.

Regards,
Ahmed

Le 30 nov. 2017 22:34, "Sanjay Mishra" <dmarc-noreply_at_freelists.org> a écrit :

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