Re: Execute to Parse %:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7931218716504

In particular, check out the my_dual part. It seems that selecting things from dual is a very common occurrence, and it does funny things to ratios. Hence Frank's answer, I suppose.

"if this is a web app, an exec/parse

ratio of 40-60 might be the best you can do. if this is client server -- much
higher numbers should be achieved.
"

Frankly, doing anything looks like Compulsive Tuning Disorder given all the other numbers.

jg

-- 
@home.com is bogus.
http://www.numberslady.com/