Execute to Parse low ratio from AWR
hi, I am working on a project. this system oracle 19c EE edition (ULA). os is rhel.
When extracting AWR, the execute to parse ratio is low. (under 20%)
Looking at SQL ordered by Parse Calls in AWR, the sql is simple.
SQL :
select count(*) from table_name where col1 = :1 and col2 = :2 and col3 <> :3 and col4 = :4
I also used bind variables, and the sql is so simple that there is nothing special about it, but I don't know why the parse rate is high.
WAS is weblogic and, use ojdbc.
(I have a low ojdbc version. Could this have something to do with it? I know I need to use ojdbc 8 or 10, but it is already deployed for operation with 7.)