DB2 Top 10 SQL por Tiempo de Ejecución

Si quieres obtener el Top Ten de sentencias SELECT con mayor tiempo de ejecución en tu base de datos IBM DB2:

 

db2 "SELECT AVERAGE_EXECUTION_TIME_S as TIME_SECONDS, NUM_EXECUTIONS as

EXECUTIONS, STMT_TEXT as TEXT FROM SYSIBMADM.TOP_DYNAMIC_SQL WHERE

upper(STMT_TEXT) like 'SELECT%' ORDER BY AVERAGE_EXECUTION_TIME_S DESC FETCH

FIRST 10 ROWS ONLY"

 

 

 

 

 

 

Espero que os sea de utilidad!

Up
1