"Select 1 from dual" parsed every time is invoked ?
We are investigating a DB which has a horrible "exec to parse" ratio ( highest value i've seen at AWR is 17%).
Among others, there is a very curious fact. Each invocation of "select 1 from dual" undergoes parsing. And that means over 10 Million calls a days (client program mantains a huge connection pool with what it seems an agressive connection check policy. No, we're not able to change this by now). According to gv$sql statistics, for this statement it has a 0,01% exec/ parse ratio
All other DB/Applications under the same technology ( Java, Spring, Hibernate, Tomcat) seem to behave correctly, with exec/parse ratios for this statement (at least 90% and usually over 99%)