1.確定正在運行的過程名 select name,locks,pins
from v$db_object_cache
where locks > 0 and pins > 0 and type='PROCEDURE';
NAME ? ? ? ? ? ? ? ? ?LOCKS???? PINS
P_ETL_CRM_DESK???? 1 ? ? ? ?1

2.查詢v$open_cursor?視圖 select sid,sql_text
from v$open_cursor
where UPPER(sql_text) like '%P_ETL_CRM_DESK%'
SID???? SQL_TEXT
143???? begin?? -- Call the procedure?? p_etl_crm_desk(v_dtdate => :

3.也可以用v$access確定 select * from v$access where object='P_ETL_CRM_DESK'; SID???? OWNER???? OBJECT ? ? ? ? ? ? ? ? ? ?TYPE
143???? KDCC???? P_ETL_CRM_DESK???? PROCEDURE

4.或者dba_ddl_locks select session_id sid, owner, name, type,mode_held held, mode_requested request
from dba_ddl_locks
where name = 'P_ETL_CRM_DESK';
SID???? OWNER???? NAME ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE ? ? ? ? ? ? ? ? ? HELD???? REQUEST
143???? KDCC???? P_ETL_CRM_DESK???? Table/Procedure/Type???? Null ? ? ? ?None

總結

以上是生活随笔為你收集整理的Oracle查看正在执行的存储过程的sid的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。