Re: Same SID, Serial# on Logical Standby

Hello Gokul,

"From time to time, not for all transactions, but for some specific ones, we are seeing inserts and updates on the standby database"

Where do you see those queries? Do you use a particular monitoring tool or you run a specific query?

În mie., 18 nov. 2020 la 06:05, Gokul Kumar Gopal < gokulkumar.gopal_at_gmail.com> a scris:

> Hello,
>
> We are currently investigating an issue with regards to some strange
> transactions appearing on the logical standby db (version 12.1).
>
> From time to time, not for all transactions, but for some specific ones,
> we are seeing inserts and updates on the standby database which we are not
> able to explain.
>
> Strangely, the sid, serial# of the session on the standby is exactly the
> same as the one on primary db.
>
> While I start to look through any reported bugs, just wanted to run this
> past this forum to check if you have any ideas on what might be happening.
>
> Many thanks,
> Gokul
>

--
http://www.freelists.org/webpage/oracle-l