SELECT step_no callno,
enq_tid deferred_tran_id,
substrb(sys.dbms_defer_query_utl.key_to_schema_name(
recipient_key,
enq_tid,
step_no), 1, 30) schemaname,
substrb(sys.dbms_defer_query_utl.key_to_package_name(
recipient_key,
enq_tid,
step_no), 1, 30) packagename,
substrb(sys.dbms_defer_query_utl.procedure_name(
1, --dbms_defer_query_utl.loc_normal_call,
chain_no,
user_data,
recipient_key), 1, 30) procname,
chain_no argcount
FROM system.def$_aqcall
WHERE substrb(sys.dbms_defer_query_utl.key_to_schema_name(
recipient_key,
enq_tid,
step_no), 1, 30) != '** NO DATA FOUND **'
AND substrb(sys.dbms_defer_query_utl.key_to_package_name(
recipient_key,
enq_tid,
step_no), 1, 30) != '** NO DATA FOUND **'
UNION ALL
SELECT step_no callno,
enq_tid deferred_tran_id,
substrb(sys.dbms_defer_query_utl.schema_name(
2, --dbms_defer_query_utl.loc_error_call,
chain_no,
user_data), 1, 30) schemaname,
substrb(sys.dbms_defer_query_utl.package_name(
2, --dbms_defer_query_utl.loc_error_call,
chain_no,
user_data), 1, 30) packagename,
substrb(sys.dbms_defer_query_utl.procedure_name(
2, --dbms_defer_query_utl.loc_error_call,
chain_no,
user_data,
0), 1, 30) procname,
chain_no argcount
FROM system.def$_aqerror
SELECT STEP_NO CALLNO
,
ENQ_TID DEFERRED_TRAN_ID
,
SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.KEY_TO_SCHEMA_NAME(
RECIPIENT_KEY
,
ENQ_TID
,
STEP_NO)
, 1
, 30) SCHEMANAME
,
SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.KEY_TO_PACKAGE_NAME(
RECIPIENT_KEY
,
ENQ_TID
,
STEP_NO)
, 1
, 30) PACKAGENAME
,
SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.PROCEDURE_NAME(
1
, --DBMS_DEFER_QUERY_UTL.LOC_NORMAL_CALL
,
CHAIN_NO
,
USER_DATA
,
RECIPIENT_KEY)
, 1
, 30) PROCNAME
,
CHAIN_NO ARGCOUNT
FROM SYSTEM.DEF$_AQCALL
WHERE SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.KEY_TO_SCHEMA_NAME(
RECIPIENT_KEY
,
ENQ_TID
,
STEP_NO)
, 1
, 30) != '** NO DATA FOUND **'
AND SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.KEY_TO_PACKAGE_NAME(
RECIPIENT_KEY
,
ENQ_TID
,
STEP_NO)
, 1
, 30) != '** NO DATA FOUND **'
UNION ALL
SELECT STEP_NO CALLNO
,
ENQ_TID DEFERRED_TRAN_ID
,
SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.SCHEMA_NAME(
2
, --DBMS_DEFER_QUERY_UTL.LOC_ERROR_CALL
,
CHAIN_NO
,
USER_DATA)
, 1
, 30) SCHEMANAME
,
SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.PACKAGE_NAME(
2
, --DBMS_DEFER_QUERY_UTL.LOC_ERROR_CALL
,
CHAIN_NO
,
USER_DATA)
, 1
, 30) PACKAGENAME
,
SUBSTRB(SYS.DBMS_DEFER_QUERY_UTL.PROCEDURE_NAME(
2
, --DBMS_DEFER_QUERY_UTL.LOC_ERROR_CALL
,
CHAIN_NO
,
USER_DATA
,
0)
, 1
, 30) PROCNAME
,
CHAIN_NO ARGCOUNT
FROM SYSTEM.DEF$_AQERROR
|
|
|