Contending that professionals who monitor web applications cannot always understand why there are back-end bottlenecks, Wily Technologies is adding visibility for Oracle databases.
The company, which specializes in dissecting the performance of Java Virtual Machines, is adding PowerPacks, or adapters, for Oracle 9i and 10g. It joins other PowerPacks available for WebLogic and WebSphere appservers, IBM z/OS, CICS and Tuxedo transaction monitors, WebSphere Business Integration, MQSeries, and web servers.
The PowerPacks don’t add probes or instrumentation. Instead they simply read the data that the originating product already exposes. In this case, it is the data exposed by Oracle’s own database console.
According to senior product line engineer Patrick Change, the value add of the PowerPack for Oracle is that it presents data to the app admin that would otherwise only be accessible to the DBA. It will let application admins answer questions like whether the problem is coming from a poorly formed SQL statement that they wrote, or from a lack of caching back on the database server.
Oracle is the first database adapter that Wily has added. Although it hasn’t made any commitments, it would be logical for Wily to eventually add similar adapters for other databases, with SQL Server, DB2, and MySQL being the obvious candidates.
This is part of a strategy to gradually provide end-to-end visibility, from the JVM upstream to back end source systems, and downstream, the end user experience. Wily’s acquisition of Timestock back in October added the ability to instrument the HTTP on the client end.
The Oracle PowerPacks are available from Wily.