parse calls=executions with cursor_sharing =EXACT or FORCE, soft parse is equl to 0

Hi there,

I have an Oracle 12.1.0.2 RAC DB.

FRom AWR % Execute to Parse is always under 8% and % Non-Parse CPU is around 80(AWR was just enabled. no old reports).

In terms of parsing, soft parse is almost zero:

parse time elapsed 5,620.3416.75

hard parse elapsed time 5,553.1016.55

Execute to parse calls = executions and are coming from the same module (I don` t have any information about application). Most SQL`s are SELECT DISTINCT with bind variales.

Below parameters are set:

OPTIMIZER_ADAPTIVE_FEATURE=TRUE

OPTIMIZER_CAPTURE_SQL_PLAN_ BASELINES=FALSE;

optimizer_dynamic_sampling=2

Is_bind_sensitive=Y

is_bind_aware=N;

SQL> select parse_calls, executions from v$sql order by parse_calls desc;