hi, I'm using Oracle version 19c and TOAD version 17.0.353.2906. I've discovered that running queries against my database creates 2 parse calls per query. Does anyone know how to fix this in TOAD so that it doesn't cause this?
Thanks
One parse is so we can get row size. We do this to optimize the fetch. Then we execute the SQL using an optimized fetch size. Parsing is very fast so I would not call this a problem, but to "fix" this:
- Update to the latest Toad (24R2)
- Go to options -> Oracle -> General. Set OCI Array Buffer Size to "Manual".
My recommendation is to leave it on Automatic.