ASH Report is reporting a Block ID that doesn't exist in DBA_EXTENTS
Hi,
I ran an ASH report (AWR returns the same data) as was seeing issues with enq: HW Contention and want to determine which Segment the contention is against.
The ASH report presented:
Event % Event P1 Value, P2 Value, P3 Value % Activity ------------------------------ ------- ----------------------------- ---------- Parameter 1 Parameter 2 Parameter 3 -------------------------- -------------------------- -------------------------- enq: HW - contention 78.10 "1213661190","7","83886314" 78.10 name|mode table space # block
I then ran this SQL to determine the Segment Name:
SELECT owner, segment_type, segment_name FROM dba_extents a WHERE file_id = 7 AND 83886314 BETWEEN block_id AND block_id + blocks - 1;
but it returned zero rows.
Further investigation against DBA_EXTENTS with this SQL: