i am on 7.5.0. I had a question with regrads to sql tuning.
The sql i am trying to tune only runs ones a day. So obviously, the data
is not in the buffer cache. So when i get the timing info, i only want to
use it for the first time. Using QSO…we did get the alternatve…
which is good and runs under 2 mins. But if we take the same alternative
and run it the next days it takes about 15 mins or so. obviously because of the
data not being in buffer cache.
The alternate that we got for 2 mins was due the the data being in buffer cache…
if you know what i mean…the original ran, alt1, alt2. alt3 ran…and so on…
so the data was in the buffer cache and thats why we got the 2 min time for that alt…
but we need something like…run all sql once…but also…include,
alter system flush buffer_cache; after each execution…so it gets the
senerio like the sql is being ran once a day(when no data is present in cache…)
is there a way to do this in QSO or any work around for this type of situation?