Oracle性能调优:Oracle性能相关常用脚本(SQL)
1、寻找最多BUFFER_GETS开销的SQL语句
--filename: top_sql_by_buffer_gets.sql SELECT * |
2、寻找最多DISK_READS开销的SQL语句
--filename:top_sql_disk_reads.sql SELECT * |
|
1、寻找最多BUFFER_GETS开销的SQL语句
--filename: top_sql_by_buffer_gets.sql SELECT * |
2、寻找最多DISK_READS开销的SQL语句
--filename:top_sql_disk_reads.sql SELECT * |