网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的考试资料：

　

标题 Oracle查看逻辑读、物理读资源占用排行的SQL语句
内容
    查看逻辑读前10的SQL：
    代码如下:
    set linesize 300;
    set pagesize 300;
    set long 50000;
    SELECT *
    FROM (
    SELECT sql_fulltext AS sql, SQL_ID,buffer_gets / executions AS "Gets/Exec",buffer_gets, executions
    FROM V$SQLAREA
    WHERE buffer_gets > 10000
    ORDER BY "Gets/Exec" DESC
    )
    WHERE rownum <= 10;
    查看物理读前10的SQL：
    代码如下:
    set linesize 300;
    set pagesize 300;
    set long 50000;
    SELECT *
    FROM (
    SELECT sql_fulltext AS sql, SQL_ID,disk_reads / executions AS "Reads/Exec",disk_reads, executions
    FROM V$SQLAREA
    WHERE disk_reads > 1000
    ORDER BY "Reads/Exec" DESC
    )
    WHERE rownum <= 10;
随便看

　

在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。

　

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间：2026/4/15 16:56:27