文章详情

短信预约-IT技能 免费直播动态提醒

请输入下面的图形验证码

提交验证

短信预约提醒成功

Oracle SET AutoTrace ON 查看执行计划

2024-04-02 19:55

关注

其中Autotrace有如下选项

SET AUTOTRACE OFF
No AUTOTRACE report is generated. This is the default.

SET AUTOTRACE ON EXPLAIN
The AUTOTRACE report shows only the optimizer execution path.

SET AUTOTRACE ON STATISTICS
The AUTOTRACE report shows only the SQL statement execution statistics.

SET AUTOTRACE ON
The AUTOTRACE report includes both the optimizer execution path and the SQL statement execution statistics.

SET AUTOTRACE TRACEONLY
Similar to SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any. If STATISTICS is enabled, query data is still fetched, but not printed.



SQL> select username, sid, serial#, server, paddr, status from v$session;

USERNAME                              SID    SERIAL# SERVER    PADDR            STATUS
------------------------------ ---------- ---------- --------- ---------------- --------
SYS                                  1631         19 DEDICATED 000000007E8D72D8 ACTIVE
SYS                                  1634          2 DEDICATED 000000007E8D9A60 INACTIVE
                                     1636          1 DEDICATED 000000007E8D9278 ACTIVE
                                     1639         12 DEDICATED 000000007E8D6AF0 ACTIVE
                                     1641          3 DEDICATED 000000007E8D8A90 ACTIVE
                                     1645          1 DEDICATED 000000007E8D5338 ACTIVE
                                     1646          1 DEDICATED 000000007E8D4B50 ACTIVE
                                     1647          1 DEDICATED 000000007E8D4368 ACTIVE
                                     1648          1 DEDICATED 000000007E8D3B80 ACTIVE
                                     1649          1 DEDICATED 000000007E8D3398 ACTIVE
                                     1650          1 DEDICATED 000000007E8D2BB0 ACTIVE
                                     1651          1 DEDICATED 000000007E8D23C8 ACTIVE
                                     1652          1 DEDICATED 000000007E8D1BE0 ACTIVE
                                     1653          1 DEDICATED 000000007E8D13F8 ACTIVE
                                     1654          1 DEDICATED 000000007E8D0C10 ACTIVE
                                     1655          1 DEDICATED 000000007E8D0428 ACTIVE

16 rows selected.

SQL> set autotrace on statistics
SQL> select username, sid, serial#, server, paddr, status from v$session where username='SYS';

USERNAME                              SID    SERIAL# SERVER    PADDR            STATUS
------------------------------ ---------- ---------- --------- ---------------- --------
SYS                                  1631         19 DEDICATED 000000007E8D72D8 ACTIVE
SYS                                  1633         33 DEDICATED 000000007E8D72D8 INACTIVE
SYS                                  1634          2 DEDICATED 000000007E8D9A60 INACTIVE


Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        955  bytes sent via SQL*Net to client
        469  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          3  rows processed

阅读原文内容投诉

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

软考中级精品资料免费领

  • 历年真题答案解析
  • 备考技巧名师总结
  • 高频考点精准押题
  • 2024年上半年信息系统项目管理师第二批次真题及答案解析(完整版)

    难度     813人已做
    查看
  • 【考后总结】2024年5月26日信息系统项目管理师第2批次考情分析

    难度     354人已做
    查看
  • 【考后总结】2024年5月25日信息系统项目管理师第1批次考情分析

    难度     318人已做
    查看
  • 2024年上半年软考高项第一、二批次真题考点汇总(完整版)

    难度     435人已做
    查看
  • 2024年上半年系统架构设计师考试综合知识真题

    难度     224人已做
    查看

相关文章

发现更多好内容

猜你喜欢

AI推送时光机
位置:首页-资讯-数据库
咦!没有更多了?去看看其它编程学习网 内容吧
首页课程
资料下载
问答资讯