Database Administration (MOSC)

MOSC Banner

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.)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center