ITPub博客

1、查找使用资源最多的SQL语句：（较高的磁盘读取（disk_reads消耗I/O）和较高的逻辑读取（buffer_gets消耗CPU）被用作衡量标准）select sql_text from (select sql_text,executions,buffer_gets,disk_readsfrom v$s...

临时表空间除外：select total.tablespace_name,       round(total.MB,2) as Total_MB,       round(total.MB-free.MB, 2) as Used_MB, &nb...