G
George Potemkin
Guest
> By the way, what is Trans id that is reported for RPLA? Empirical observations: 'Trans id' seems to be a Trid of the last processed note. In other words it's an id of transaction that was in Active state on source database. By the way, RL_TMSAVE notes do sent to a target db but they are ignored by replication agent. It's likely that these notes do not affect 'Trans id' on target db. 'Trans State' on target db is either Active or None (a.k.a. Dead). 'Status: Active Transactions' screen in promon seems always to contain one and only one row. 'BI Rwrites' reported for "transaction" is in fact the total number of recovery notes written by replication agent since its startup (so it's not per transaction). I don't have enough data to say if 'Tx start time' is a transaction start time on source or on target db.
Continue reading...
Continue reading...