SQL Performance (MOSC)

MOSC Banner

"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%)

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