05 2023 档案

Oracle 性能慢排查脚本
摘要：查看总消耗时间最多的前100条SQL语句 select * from ( select v.sql_id,v.child_number, v.sql_text,last_load_time,v.PARSING_USER_ID, ROUND(v.ELAPSED_TIME / 1000000 / (CA 阅读全文
posted @ 2023-05-30 14:54 oioele 阅读(178) 评论(0) 推荐(0)
SQLServer　实用语句之慢、触发器、锁
摘要：查询过去执行的查询慢 SELECT t.text, (qs.total_elapsed_time/1000) / qs.execution_count AS avg_elapsed_time, (qs.total_worker_time/1000) / qs.execution_count AS a 阅读全文
posted @ 2023-05-30 14:40 oioele 阅读(69) 评论(0) 推荐(0)