Ridiculous. Any downside of using a session variable is far out-weighed
by the downside of executing 10M sql statements.

-----Original Message-----
From: Johnson Poovathummoottil [mailto:[Email Address Removed]
Sent: Wednesday, July 31, 2002 3:21 PM
To: LazyDBA.com Discussion
Subject: extremely high number of executions


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page