Locks on temporary tables
ExorNov 2 2012 — edited Nov 13 2012Hello,
Does anyone have any background information on temporary tables internals? Is the locking mechanism any different from heap tables?
I am asking because I am noticing that row exclusive locks are kept on global temporary tables on commit preserve until the session disconnects. I don't understand why exclusive row locks are kept across commit statements. Can someone explain this?
Thank you,