sql监控

所有的snapshot都是从share memory里取出来的，如果没开monitor switch，也就是计数器的值不会被记录，你会看到SQL的text，但是看不到计数器的值。

    Dynamic SQL Snapshot Result

Database name                      = HADR97

Database path                      = /home/zxianing/zxianing/NODE0000/SQL00010/

Number of executions               = 1
Number of compilations             = 1
Worst preparation time (ms)        = 49
Best preparation time (ms)         = 49
Internal rows deleted              = Not Collected
Internal rows inserted             = Not Collected
Rows read                          = Not Collected
Internal rows updated              = Not Collected
Rows written                       = Not Collected
Statement sorts                    = Not Collected
Statement sort overflows           = Not Collected
Total sort time                    = Not Collected
Buffer pool data logical reads     = Not Collected
Buffer pool data physical reads    = Not Collected
Buffer pool temporary data logical reads   = Not Collected
Buffer pool temporary data physical reads  = Not Collected
Buffer pool index logical reads    = Not Collected
Buffer pool index physical reads   = Not Collected
Buffer pool temporary index logical reads  = Not Collected
Buffer pool temporary index physical reads = Not Collected
Buffer pool xda logical reads      = Not Collected
Buffer pool xda physical reads     = Not Collected
Buffer pool temporary xda logical reads    = Not Collected
Buffer pool temporary xda physical reads   = Not Collected
Total execution time (sec.microsec)= Not Collected
Total user cpu time (sec.microsec) = Not Collected
Total system cpu time (sec.microsec)= Not Collected
Total statistic fabrication time (milliseconds) = Not Collected
Total synchronous runstats time  (milliseconds) = Not Collected
Statement text                     = select * from t5