Is there a way for Shareplex to calculate the number of transactions or operations handled by it (4255735)

It is desired to calculate the transactions or operations that were processed by Shareplex in a given time period on source and/or target.

General information.

On source there is no direct way to compute the number of transactions or operations that were processed by Shareplex in a given time. One may have to use alternative means like LogMiner, etc, to estimate it. On target it is possible so issue the command show post detail on different times (say at the same time on two consecutive days) and then measure the difference between various statistics that are presented in the two outputs to arrive at the correct figure. The output includes transactions posted, and is also broken down into INSERTs, UPDATEs and DELETEs. If named Post queues are involved, then the statistics from various named queues have to be added to arrive at the correct figure.

One thing to note is that in a steady state (where the data flowing in Shareplex queues is not unduly backlogged at source or target) it is one in the same thing whether the computation is done on source or target so the computation done at target should suffice.

The following is a sample show post detail output showing statistics like Transactions posted, Insert operations, Update operations and Delete operations. To compute any of the statistics, say transactions posted, one needs to issue show post detail on two different time intervals and then compute the difference between the respective statistics. For example, if the number of transactions posted are to be determined, then the value of Transactions posted from two output of show post detail are taken and their difference computed to arrive at the answer.

Another thing to note is that the statistics are cumulative over a period of time and are reset upon the bouncing of Post process. So the correct value can only be computed if the Post process is not bounced between the time interval in question.

sp_ctrl> show post detail

Host : batch01
Source : o.SID1 Queue : queue_name

Operations
Target Status Posted Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------

o.SID1 Running 400995 11-May-07 10:24:17 130484 130387

Last operation posted:
Redo log: 13133 Log offset: 104099176
INSERT in KCFC_USER.ACLINKC at 05/09/07 14:54:31

Post state : Commit transaction
Activation Id : 19
Current transaction Id : 2
ID of blocking transaction : 0
Number of open transactions : 0
Number of messages read released : 500

Operations posted : 100
Transactions posted : 5

Insert operations : 50
Update operations : 20
Delete operations : 15

Key cache hit count : 0
SQL cache hit count : 70 %