Database Search Caching - Oracle & TRIM 7.1.2 1879
Good Afternoon All,
I was wondering if anyone could explain what happens when a user conduct the same search, say title word search ‘Smith’, returning 50000+ records within 80seconds. The second time the person performs the same search it takes less than 20 seconds. This is done within the same TRIM session.
Now, the question is, Does TRIM caches user searches? If so, where is this cached search kept?
Is there a HPTRIM document that can explains how oracle db works with TRIM?