×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

Yes, there is. run ?/rdbms/admin/catblock.sql

celiaxi(CICI)
本文发表在 rolia.net 枫下论坛SYS@remdev:phantom:SQL>select * from v$version;

BANNER
------------------------------------------------------------------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SYS@remdev:phantom:SQL>desc dba_locks
Name Null? Type
----------------------------------------------------------------- -------- --------------------------------------------
SESSION_ID NUMBER
LOCK_TYPE VARCHAR2(26)
MODE_HELD VARCHAR2(40)
MODE_REQUESTED VARCHAR2(40)
LOCK_ID1 VARCHAR2(40)
LOCK_ID2 VARCHAR2(40)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#852824@0)
Last Updated: 2002-11-13
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / Is there table or view as "dba_locks" in oracle 8i? -blackswan(uglyduck); 2002-11-12 (#851150@0)
    • There is no dictionary view as 'DBA_LOCK', but there is a 'v$LOCK' -handd(大熊猫®); 2002-11-13 (#852575@0)
    • Yes, there is. run ?/rdbms/admin/catblock.sql -celiaxi(CICI); 2002-11-13 {1355} (#852824@0)
      本文发表在 rolia.net 枫下论坛SYS@remdev:phantom:SQL>select * from v$version;

      BANNER
      ------------------------------------------------------------------------------------------------------------------------
      Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
      PL/SQL Release 8.1.7.4.0 - Production
      CORE 8.1.7.0.0 Production
      TNS for Solaris: Version 8.1.7.4.0 - Production
      NLSRTL Version 3.4.1.0.0 - Production

      SYS@remdev:phantom:SQL>desc dba_locks
      Name Null? Type
      ----------------------------------------------------------------- -------- --------------------------------------------
      SESSION_ID NUMBER
      LOCK_TYPE VARCHAR2(26)
      MODE_HELD VARCHAR2(40)
      MODE_REQUESTED VARCHAR2(40)
      LOCK_ID1 VARCHAR2(40)
      LOCK_ID2 VARCHAR2(40)
      LAST_CONVERT NUMBER
      BLOCKING_OTHERS VARCHAR2(40)更多精彩文章及讨论，请光临枫下论坛 rolia.net

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论