The Single-threaded Post (STP) is not moving past a certain DML and appears to be hung for a very long time. When the view v$session_wait is queried, it is observed that STP is waiting for a lock to be released. Stopping and restarting Post or Shareplex is not helping.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy