V$SESSION cache buffers chains latch row_wait columns 10g

I haven't seen this documented anywhere, but it looks like the row_wait* columns in v$session show you which block a latch is on when you have a cache buffers chains latch in 10g.

Here is the query I'm using:

SELECT s.P1raw
latchaddress,s.sid,o.owner,o.object_name,o.SUBOBJECT_NAME,o.object_type,

s.ROW_WAIT_FILE#,s.ROW_WAIT_BLOCK#,s.ROW_WAIT_ROW# FROM v$session s,dba_objects o
WHERE s.ROW_WAIT_OBJ#=o.OBJECT_ID AND
s.event='latch: cache buffers chains'
ORDER BY row_wait_file#,row_wait_block#;

• Bobby