sysproxysessions table

The sysproxysessions table contains information about each of the sessions that are using redirected-write functionality. This table is only valid on the secondary server.

The following table provides information about the columns in the sysproxysessions table:
Column Type Description
session_id integer ID of a user's session on the secondary server.
proxy_id integer ID of the proxy distributor on behalf of which the proxy agent thread (TID) is running
proxy_tid integer Transaction ID of the proxy agent thread running on the primary server. This ID is created by the proxy distributor to handle work from the secondary server session.
proxy_txn_id integer Number of the current transaction. These numbers are unique to the proxy distributor.
current_seq integer The sequence number of the current operation in the current transaction.
pending_ops integer The number of operations buffered on the secondary server that have not yet been sent to the primary server.
reference_count integer Indicates the number of threads (for example, sqlexec, sync reply, recovery, and so on) that are using the information for this transaction. When reference_count equals 0, the transaction processing has completed (either successfully or unsuccessfully).

Copyright© 2019 HCL Technologies Limited