Database Tuning (MOSC)

MOSC Banner

ASH Report is reporting a Block ID that doesn't exist in DBA_EXTENTS

in Database Tuning (MOSC) 3 commentsAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center