Hi All,

We have an application which executes one sql
statement more than 10 million times a day. Everything
is good about the sql, well tuned, uses indexes, parse
only once, etc. The number of concurrent users in this
database seems to around 60, but we see an average
1500 executions/sec.

We questioned the developers about the sql as we had
seen 80% to 95% latch sleeps on library cache
constantly. They seem to be hitting the database every
time a page is refreshed instead of storing the
retrieved data some where for later use.

The developers are of the opinion that cookies and
session variables are considered "the much
detested and reviled Satan and Lucifer of all
"stateful" web apps".

Any comments/opinion?

__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
Oracle LazyDBA home page