modes of locking:exclusive,share
types of locks:dml,ddl,internal
v$lock type tm:id1 -> table and meterailize log
v$lock type tx:id1 -> high 16 bit =xidusn(v$transaction) low 16 bit = xidslot(v$transaction)
v$lock v$transaction v$session
tools:v$lock v$locked_object dba_waiters dba_blockers
Oracle monitoring and detecting lock contention
最新推荐文章于 2022-10-22 20:30:20 发布