cursor: pin S wait on X

Few weeks back thread came up on oracle-l freelist regarding “cursor: pin S wait on X” event . Tanel Poder replied to this thread with excellent explanation. You can read full thread here   This wait happens when your session wants to examine / execute an existing child cursor – but it’s being pinned in X…