Re: tuning question

Posted by Laurel on Oct 31, 2018; 10:35pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tuning-question-tp6880p6898.html

Hi Erman!
Thx as always for an answer..
This sql calles in loop in report per row .
Its feels like query performs 1631 executions and all those blocks are on memory disk as takes 0.314 sec per execution
then for the rest of data it goes to the cold disk as same execution plan but for  single execution takes 34,864 sec ..
I asked our server admin - its all on same disk and there is no more cold/hot disks as long time before...

So its weird.

1. Its the same sql running  in a loop in a report. So, always the same amount of data.
2. Same loop after 1631 executions speed drop 0,314->34
3.200% sure its the same executon plan
4. When flush, same thing
5. here is the trace file from report.

Anything comes to your mind ?report1.doc
Thx!