This article from Doug Burns gives an great insight of the possibilities and advantages a…
Year: 2007
AMIS is proud to announce their AMIS Query (free technical seminar), targeted at Oracle Database Architects and Database Administrators.
How the Middle Tier is Slowing Down Your Database
Multi tier systems are very common today. Most of these systems include a web server, an application server and a database. They also rely heavily on the very recent HTML and Java technologies. In fact, these technologies are relatively new and a whole set of new (and young) developers have been exploring them. This presentation is exploring the mistakes that are made in the middle tier and how they affect the database and what can be done to improve performance dramatically with some simple changes.
Based upon: http://forums.oracle.com/forums/thread.jspa?threadID=498374
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
5 rows selected.