select event,p1,p2,p3 from v$session where event like 'enq%'; EVENT P1 P2 P3 1 enq: HW - contention 1213661190 6 48639810 2 enq: HW - contention 1213661190 6 48639810 通过P3进行DBMS_UTILITY转换可以获知发生争用的文件和block SQL> select DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(48639810) FILE#, DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(48639810) BLOCK# from dual; FILE# BLOCK# 1 11 2502466 select owner, segment_type, segment_name from dba_extents where file_id = 11 and 2502466 between block_id and block_id + blocks - 1; OWNER SEGMENT_TYPE SEGMENT_NAME 1 TLCB TABLE WEBSERVICE_MSG 原因:表空间满了,数据库忙于分配空间。 SQL> select parameter1,parameter2,parameter3 from v$event_name where name='enq: HW - con