I am trying to use my own SQL to get some information about Blocking and Waiting locks. In Oracle Performance Manager Blocking/Waiting Locks Chart, there is a rowid listed. I would like to know how I can get the rowid (that is being blocked and or waited on) by writing a SQL statement rather than having to go into Oracle Performance Manager. Any help would be greatly appreciated.

Thanks,
Joel