trace level to find locks

Hi,

Is there any trace event# available to trace only object locks? I know 10046, level 12 gives the information about parsing, executes, fetches, bind variables, and waits but i want to check the trace event only for object locks.

Appreciate your inputs.

Thanks,

why would you need a trace event, you can get everything you want from the v$ views

agree with you Davey ... instead of querying from multiple views just trying to find some easy way to do it.

Thanks,

multiple views?

v$lock is one

Thanks Davey.

Thanks,

U can check this view also v$lockrel

Quote:

---

Originally Posted by vinoth2506

U can check this view also v$lockrel

---

:confused: ???

Quote:

---

Originally Posted by vinoth2506

U can check this view also v$lockrel

---

worst first post EVER