• oracle 查询谁在用undo


    SELECT TO_CHAR(s.sid)||','||TO_CHAR(s.serial#) sid_serial,
    NVL(s.username, 'None') orauser,
    s.program, r.name undoseg,
    t.used_ublk * TO_NUMBER(x.value)/1024/1024||'M' "Undo"
    FROM sys.v_$rollname r,
    sys.v_$session s,
    sys.v_$transaction t,
    sys.v_$parameter x
    WHERE s.taddr = t.addr AND r.usn = t.xidusn(+)
    AND x.name = 'db_block_size'

  • 相关阅读:
    20210312
    20210311
    20210310
    例5-1
    例5-2
    例4-12-2
    例4-12
    例4-11
    例4-10
    例4-9
  • 原文地址:https://www.cnblogs.com/hankyoon/p/5174555.html
Copyright © 2020-2023  润新知