| enq: TM - contention [message #145756] |
Sun, 06 November 2005 01:29  |
satishleo@gmail.com
Messages: 2
Registered: November 2005
|
Junior Member |
|
|
Can some one tell me how to create this contention in a test environment.
new 1: select event_id,name from v$event_name where event_id=668627480
EVENT_ID NAME
---------- -----------------------------------------------------
668627480 enq: TM - contention
And even any links related to enq: TM - contention would be helpful.
Thanks
Satish
|
|
|
|
| Re: enq: TM - contention [message #145781 is a reply to message #145756] |
Sun, 06 November 2005 17:05  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Hmmm, TM is a DML Enqueue.
You will probably get a better answer from a DBA (I am a progammer) but I think DML Enqueues are a resources required by uncommitted INSERT/UPDATE/DELETE statements. They are not locks.
You might be able to raise the TM enqueue wait by running HEAPS of DML in multiple sessions without committing. Better yet, do some searches on DML Enqueue in this forum, Google, elsewhere.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
