Database and SQL Tuning

For a vast majority of WebLogic applications, database access is a critical piece of functionality and potentially a good source for performance tuning. For example, there can be issues with the number of database accesses that an application is making, which might encourage an application developer to cache in memory values that don't change frequently, instead of retrieving them each time. Or there could be an issue with how long a particular query is taking to return, which might be improved by adding indexes or using temporary tables on the database. There are several other factors concerning the general performance of the database itself as well as WebLogic's communication with the database, which we will now examine ...

Get BEA WebLogic Server™ 8.1 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.