Recently installed TOAD 220.127.116.11 and Spotlight 10.3.0.1632. Total Parse Wait Time Ratio Alarm constantly fires [yellow and sometimes red] 10.7 % wait over 30 sec. There is a Library Cache Miss Rate alarm on Shared Pool Used as well [aqua color].
Vendor reviewed Spotlight data and says “there isn’t actually a problem. TOAD is complaining because the axiUm application is sending a lot of “literals” to the database, and those literals have to be parsed (hence, high level of parsing). And that’s true, we are, because that’s just the way the application is written.”
Vendor requires CURSOR_SHARING must be set to ‘EXACT’. SESSION_CACHED_CURSORS currently set to default 50, OPEN_CURSORS set to 900 per vendor recommendation. Shared Pool size is 1.7 Gb 73% used on average.
Is it possible to tune this situation?