Blocking Sessions in PLM from the Database or from any other source

[aachanta]

Hi All,

Can we all know through an SQL Query or a procedure the list of all blocking sessions in PLM which is blocking other processes to wait or run lately?

In case if this cannot be done through DB can we do it through any other means.

[MichaelChatel · Accepted solution]

Aachanta,

If you're having a specific issue, with blocking sessions, you could check out this knowledge article we have published:

https://www.ptc.com/en/support/article/CS66532

It's an oft-used article, to help identify blocking sessions, or why DB transactions seem to be hung or stuck.

If you are having an issue like that, I'd suggest opening a Support case.

Mike