Help understand raw trace data.
Date: Sat, 5 Sep 2009 15:58:16 +0000 (GMT)
The procedure accepts the following parameters:
And it is being called via JDBC, but I have no access to the calling routine.
The main problem is that this query is used by a telephone based application and at times takes 2 seconds or more to respond but most of the time it has a subsecond response. However the database is being blamed but I do not think this is the case, I am looking at gathering evidence and the trace was my starting point.