Re: Lock Monitor Question

From: tkyte_at_us.oracle.com (Thomas Kyte) >> While replying to original post on lock question stated that >> Oracle maintains row level locks right with the data. In order to find if a row is locked, we goto the row. <<

Thomas, I believe what you say and I am glad to know this, but can you tell the newsgroup how Oracle handles row locks for rows contained in a dirty buffer pool block that gets flushed to disk to make room in the pool before it is commited? Does the rdbms have to re-read and re-write the block again to remove the row level locks or does it transfer them to memory? Are they stored in the initrans work area or taken from free space?

Also, the original poster and othera may be interested to know that starting with ver 7.2 the v$session table has 4 columns that contain the rowid that a session is locked on. The numbers are in decimal if my memory is correct and have to be converted to hex to match the results of a select rowid. Maybe someone out there can generate the code to translate the decimal to hex representation. I would like to try, but keep having other people ask me to do work for them..

Please carbon me on post if possible.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Wed Jan 28 1998 - 00:00:00 CST