Home » Server Options » Replication » Max packet size propogated (Oracle 11.1 , linux)
Max packet size propogated [message #676224] Tue, 21 May 2019 11:18 Go to next message
Manishkumar
Messages: 36
Registered: May 2019
Member
Hi,

I am using multi master asynchronous replication with database A as master definition site and database B as master site. Now while updating a table in database A which is part of replication group. How many number of packet will sent by oracle for replicating data to B and what could be the max possible size of a packet sent by oracle for replication?

Thanks,
Manish
Re: Max packet size propogated [message #676226 is a reply to message #676224] Tue, 21 May 2019 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It depends on:
1/ Your TCP/IP stack configuration
2/ Your sqlnet.ora configuration
3/ Your databases activity (how many updates and how large they are)

I hope you are in a local network or have small volumes of updates (11.1 /forum/fa/1599/0/).

Re: Max packet size propogated [message #676236 is a reply to message #676226] Wed, 22 May 2019 10:57 Go to previous messageGo to next message
Manishkumar
Messages: 36
Registered: May 2019
Member
Can you explain in detail. How we come to know? How it relates to sqlnet.ora? I just want to check how many max byte a packet will support and how many packets will go?
Re: Max packet size propogated [message #676237 is a reply to message #676236] Wed, 22 May 2019 11:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://lmgtfy.com/?q=oracle+sdu+size

What will you do differently after you know max packet size & how many packets go?
Re: Max packet size propogated [message #676238 is a reply to message #676236] Wed, 22 May 2019 11:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Manishkumar wrote on Wed, 22 May 2019 17:57
Can you explain in detail. How we come to know? How it relates to sqlnet.ora? I just want to check how many max byte a packet will support and how many packets will go?
Did you click on the link I made the effort to search for and provide you?

Re: Max packet size propogated [message #676239 is a reply to message #676238] Wed, 22 May 2019 11:35 Go to previous messageGo to next message
Manishkumar
Messages: 36
Registered: May 2019
Member
I checked that. so, the oracle send exactly SDU size data or there is some overhead of header or any other extra bytes is there
Re: Max packet size propogated [message #676240 is a reply to message #676237] Wed, 22 May 2019 11:36 Go to previous message
Manishkumar
Messages: 36
Registered: May 2019
Member
I checked that. so, the oracle send exactly SDU size data or there is some overhead of header or any other extra bytes is there. I just want to check that how many bandwidth it will require.
Previous Topic: OGG-01232
Next Topic: data dictionary log path
Goto Forum:
  


Current Time: Thu Mar 28 07:44:10 CDT 2024