Paul Dorsey and Michael Rosenblum published this article in the IOUG Web Architecture Best Practices Booklet (Collab’09 edition) in 2009. The Introduction is below:
Many of the performance tuning techniques applied to client/server applications that consisted of rewriting poorly written SQL code and tuning the database itself are not helpful when dealing with Web applications that are frequently unaffected by these performance improvement approaches. This tip describes some of the most common problem areas when dealing with Web application performance issues.
You can read the whole article. IOUG stands for Independent Oracle User Group and it is a user group that we highly recommend. They have an annual conference (Collaborate) in April and a large number of online resources for members.
The “Best Practices” booklets gather the tips and best practices from a variety of sources including: the Oracle community; through SIG leaders; through COLLABORATE presenters; and from the IOUG SELECT reviewers/board. These booklets have resonated well with the Oracle community as it’s generally applicable to Oracle users. You must be a paid IOUG member to access the Tip Booklet.