I wrote an application that queries oracle v$sqlarea and dumps data to my own database for further analysis. I noticed something very strange - sometimes data in the v$sqlarea shows less executions than before. I'm pretty sure that the oracle cache was not cleaned (the first load time of query is still the same, and since I query oracle each minute I dont believe that in this one minute the query was executed 100k+ times). Can anybody explain how this is possible?
Asked
Active
Viewed 210 times
1 Answers
0
Ok, so I asked this on Oracle forum as well, and I believe that the correct answer is this one https://community.oracle.com/message/12980175#12980175
Nadir
- 1,369
- 1
- 15
- 28