Re: tuning question

Posted by ErmanArslansOracleBlog on Oct 31, 2018; 1:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tuning-question-tp6880p6890.html

Hi Laurel,

1)Is the amount of data almost the same?
2)Is the first execution fast? (all the subsequent executions are slow?)
3)Are you sure that those queries were using the same execution plan?
4)What happens when you flush the shared pool and retest these slow queries?
5)send me an autotrace output.. (autotorace on)