sp_qstatmon in the prodir/util does not work for MTP (Multi Threaded Poster) it gives the following error when run.
sp_qstatmon[19]: TRUE: bad number
The script works without any issues for STP (SingleThreaded Poster) and not for MTP (Multi Threaded Poster)
WORKAROUND:
A modified script for MTP is attached to this solution so you can use with Shareplex for Oracle.
STATUS:
Waiting for fix in a future release of Shareplex for Oracle.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center