每次轮询是iMC后台是执行一个查询sql top10语句的命令,查出来是什么就做对应的展示这意思。至于这些top 10的语句是多长时间内执行的其实没关注的。比如如下是oracle数据库的查询top10的命令:
$oracle_monitorType@$ip_address@$port@$oracle_instance##$user_name##$password##$oracle_query_timeOut##$oracle_connect_timeOut###select sql_id, sql_text, elapsedtimeavg, elapsedtime,cputimeavg, cputime, executions, disk_reads, buffer_gets from (select sql_id, sql_text, decode(executions,0,0,trunc(elapsed_time/1000000)/executions) as elapsedtimeavg,trunc(elapsed_time/1000000) as elapsedtime,decode(executions,0,0,trunc(cpu_time/1000000)/executions) as cputimeavg, trunc(cpu_time/1000000) as cputime, executions, disk_reads, buffer_gets from v%dollar%sqlarea order by elapsedtimeavg desc) WHERE rownum<=10###sqlId##sqlText##elapsedTimeAvg##elapsedTime##cpuTimeAvg##cpuTime##executions##diskReads##bufferGets###9###servalRecords
那指标中显示的读次数表示的就是一个轮询周期内读了几次,是这样吗老师?
每次轮询是iMC后台是执行一个查询sql top10语句的命令,查出来是什么就做对应的展示这意思。至于这些top 10的语句是多长时间内执行的其实没关注的。比如如下是oracle数据库的查询top10的命令: $oracle_monitorType@$ip_address@$port@$oracle_instance##$user_name##$password##$oracle_query_timeOut##$oracle_connect_timeOut###select sql_id, sql_text, elapsedtimeavg, elapsedtime,cputimeavg, cputime, executions, disk_reads, buffer_gets from (select sql_id, sql_text, decode(executions,0,0,trunc(elapsed_time/1000000)/executions) as elapsedtimeavg,trunc(elapsed_time/1000000) as elapsedtime,decode(executions,0,0,trunc(cpu_time/1000000)/executions) as cputimeavg, trunc(cpu_time/1000000) as cputime, executions, disk_reads, buffer_gets from v%dollar%sqlarea order by elapsedtimeavg desc) WHERE rownum<=10###sqlId##sqlText##elapsedTimeAvg##elapsedTime##cpuTimeAvg##cpuTime##executions##diskReads##bufferGets###9###servalRecords
好的,感谢