OraFAQ Forum: Replication » Max packet size propogated

Home » Server Options » Replication » Max packet size propogated (Oracle 11.1 , linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Max packet size propogated [message #676224]

Tue, 21 May 2019 11:18

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

Report message to a moderator

Re: Max packet size propogated [message #676226 is a reply to message #676224]

Tue, 21 May 2019 11:43

Michel Cadot
Messages: 68502
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/

Report message to a moderator

Re: Max packet size propogated [message #676236 is a reply to message #676226]

Wed, 22 May 2019 10:57

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?

Report message to a moderator

Re: Max packet size propogated [message #676237 is a reply to message #676236]

Wed, 22 May 2019 11:09

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?

Report message to a moderator

Re: Max packet size propogated [message #676238 is a reply to message #676236]

Wed, 22 May 2019 11:22

Michel Cadot
Messages: 68502
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?

Report message to a moderator

Re: Max packet size propogated [message #676239 is a reply to message #676238]

Wed, 22 May 2019 11:35

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

Report message to a moderator

Re: Max packet size propogated [message #676240 is a reply to message #676237]

Wed, 22 May 2019 11:36

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.

Report message to a moderator

Previous Topic:	OGG-01232
Next Topic:	data dictionary log path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 26 21:35:28 CDT 2023