Timeout configuration in JEE/SOA/RDBMS technology stack

Setting proper timeouts in JEE/SOA/RDBMS technology stack is sometimes a magic. This digram helps a little.

WebLogic JDBC monitor

WebLogic provides rich JDBC monitoring and diagnostics capabilities (debug, WLDF), however does not provide lightweight facility to report executed SQL statements lasting longer than predefined time. Moreover available out of the box subsystems are little too heavy, in area of configuration and generate too much information. Practical use case is to be informed only about SQL executions which consumed too much time. Presented solution delivers such lightweight SQL monitoring functionality. 

Identity generation in load balanced WebLogic/RAC environment (2of3)

This note specifies technical aspects of identity generation adjusted to multi node environment utilizing load balanced channels to Oracle RAC database. It's detailed extension of document "Maximize insert throughput in Oracle RAC system".

Maximize insert throughput in Oracle RAC system (1of3)

Many systems use surrogate primary keys generated by a sequence generator. It's simple, easy, and guarantees unique values. Unfortunately in a multithreaded environment it leads to issues with concurrent memory structures updates. The problem is additionally magnified in distributed environment with cache coherency. This analysis presents the problem and aims to find solutions.