ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claus Ibsen (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-99) Add logging of long running SQL statements
Date Fri, 16 Feb 2007 10:30:05 GMT

    [ https://issues.apache.org/jira/browse/IBATIS-99?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12473667

Claus Ibsen commented on IBATIS-99:

I have been on numerous projects where we had really long running SQL that got out of hand.
Since Oracle on long the SQL when the query ends the operation staff could not always give
And Oracle did not log the bind parameters so it was hard to find the culprits among the many
millions of SQL executed every day.

We ended build in some SQL logging where we could set a min time value for the long running
SQL's to be logged (with bind parameters outputted also).

> Add logging of long running SQL statements
> ------------------------------------------
>                 Key: IBATIS-99
>                 URL: https://issues.apache.org/jira/browse/IBATIS-99
>             Project: iBatis for Java
>          Issue Type: New Feature
>          Components: SQL Maps
>            Reporter: Larry Meadors
>            Priority: Trivial
> It would be useful to have a way to log long running statements. 
> Ideally, the implementation would allow us to define a global value for the definition
of "long running", and maybe a per statement definition, too.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message