At times users have this question as to whether it is possible to ignore activities of a given session on the source database. This solution delves on whether this is doable.
General information.
It is not possible in Shareplex to selectively ignore activities of a given session. It is possible to ignore a certain transaction executed by a session. See Shareplex Administrator Guide Chapter titled Shareplex Utilities section titled Preventing DML transactions from replicating with create_ignore.sql. It is also possible to ignore activities of a certain user altogether by configuring the parameter SP_OCT_DENIED_USER_ID (starting with Shareplex 7.0 and up). See Shareplex Reference Guide for details.
