2019-03-21から1日間の記事一覧

スロークエリ確認

DB

Oracle SELECTsql_id,sql_fulltext,elapsed_time,executions,elapsed_time/executions/1000000FROM v$sqlstatsWHERE executions > 0ORDER BY elapsed_time/executions/1000000 ; SELECTsql_id,ELAPSED_TIME_TOTAL,EXECUTIONS_TOTAL,ELAPSED_TIME_TOTAL/EXECU…