sql监控
SQL Statement Information (STATEMENT) = OFF
开关没有打开，
我执行了java-web应用程序中的一个操作，想查看后台对应的sql是啥？？
监控如下：
我get snapshot for dynamic sql on testdb 后结果竟然找到了那条语句，我发现开关没打开呀，怎么也 能监控到呢？？？
开关没有打开，
我执行了java-web应用程序中的一个操作，想查看后台对应的sql是啥？？
监控如下：
我get snapshot for dynamic sql on testdb 后结果竟然找到了那条语句，我发现开关没打开呀，怎么也 能监控到呢？？？
9 同行回答
Statement – 4% - 8% (much less for static SQL)
• How long an application has been idle
• Type of statement (static/dynamic) and operation being performed
(Prepare/Open/Fetch/etc)
• Cursor Name
• Statement start, stop and elapsed time
• Statement Text (shown by default in get snapshot for dynamic sql)
• Number of sorts, rows fetched
• Estimates of the statement cost, number of rows returned
• Number of agents working on a statement and the degree of parallelism 收起
• How long an application has been idle
• Type of statement (static/dynamic) and operation being performed
(Prepare/Open/Fetch/etc)
• Cursor Name
• Statement start, stop and elapsed time
• Statement Text (shown by default in get snapshot for dynamic sql)
• Number of sorts, rows fetched
• Estimates of the statement cost, number of rows returned
• Number of agents working on a statement and the degree of parallelism 收起