Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Execute to Parse %:
I did some more research. A cursor is not parsed when the application
keeps executing the same cursor over and over aging with the exact same
values in the bind variables. So the Execute to Parse Ratio is really
measuring how often the application keeps executing the same SQL
statement (and getting the exact same results).
Not sure why the target is 100%. A low ratio in my case really means users are passing different values to bind variables and querying different rows the DB. Received on Fri Jul 01 2005 - 08:07:33 CDT