Tuesday, March 28, 2006

Oracle Riddles: Now that is interesting.

A process can prevent me from staking the claim for another. Users sometimes need me to know if they can secure a spot where another process may have been before. Needless to say, I am a pretty big deal, and users are very interested in me. However, when some stop by for a visit they often feel I haven't cleaned up very well. Do you know what I am?

6 Comments:

Anonymous Anonymous said...

the oracle process monitor (pmon) ?

3/30/2006 2:19 AM  
Blogger Eric S. Emrick said...

Any other guesses ;-) ?

3/30/2006 8:25 AM  
Blogger Mike Wielonski said...

I'll bite - The transaction table in the rollback segment header block.

3/30/2006 9:27 AM  
Blogger Steve Eck said...

A row level lock, I think.

3/30/2006 10:08 AM  
Blogger Steve Eck said...

Actually, I would revise my guess to be Interested Transaction List.

3/30/2006 10:40 AM  
Blogger Eric S. Emrick said...

Steve,

"Interested Transaction List" is indeed the answer I was looking for. Nice job. I thought the title "Now that is interesting" in conjunction with "users are very interested in my" and "I haven't cleaned up very well" would have given it away. Users will sometimes, but not always, need the ITL of a block to determine if they can lock a row. Sometimes the row is not locked. Sometimes the row lock byte indicates the row is "locked" when in fact it is not. So, we need the ITL entry for that row to get the transaction status stored in the undo segment header to determine if the row can be locked. Anyway, partial credit to Mike Wielonski is granted, given the somewhat ambiguous language used. Thanks for playing!

3/30/2006 10:50 AM  

Post a Comment

<< Home