Re: tuning question

Posted by ErmanArslansOracleBlog on Nov 01, 2018; 8:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tuning-question-tp6880p6902.html

I think that, after a while, you encounter a resource problem.
Probably, it is about memory.
It should be about SGA (buffer cache)
Your query is doing db file sequential read. (index read)
It spends its time on fetching.


Did you check ASH and/or AWR during the execution of these slow queries?
Do you see buffer waits? What do you see exactly?