_ve execute to parse ratio
Sai Pradyumn, January 21, 2017 - 11:31 am UTC
Hi McDonald
Thanks for your reply.I had come across with this scenario.
But in my production environment there are some queries
where the execute to parse ratio is negative.
Following are categories of those queries.
1:Some of them are from anonymous blocks.
2:Some of them are from application with bind variables
with Prepared statement of JDBC.
3:Some of them are part of Materialized view Fast refresh
Now i am getting why these queries are having the highest parse call totals.
If the parse calls totals if highest than the execution totals , will to go hard parsing always ?
Is there are relation between parsing type and Execute to parse ration
October 09, 2023 - 4:53 am UTC
Link is gone
Alain L., October 06, 2023 - 6:44 am UTC
Hi Connor,
the last link you provided in the comment is now leading to a plumbing company :-)
I don't think this is on purpose.
October 09, 2023 - 4:54 am UTC
Well there you go :-)
I've updated it to a new link.
Thanks for letting us know