Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

12c Database : Network enhancements – DEFAULT_SDU_SIZE to 2M

How many you know this structure at first glance, I am sure the old DBA junkies will say what this called immediately, but for those who does not know this diagram is called Network OSI diagram for Oracle and layers between client and database servers and how oracle connects.

Oracle uses different methods to connect to database server and when used Oracle Net it uses the above network model to communicate with Oracle database. Oracle client has to be installed in the other end and it can communicate using Net layer and database layer uses same Net 8 foundation layer to listen the requests.

OSI Model depicts the following,

 

Layer#

Name

Description

7

Application

Standard communication services and applications that everyone can use

6

Presentation

Layer that takes data from application and presents it  in a format that is recognized by other layers; Functions like character set conversion is done by this layer

5

Session

Establishes, maintain & end connections

4

Transport

Delivers data without errors in sequence and no data loss or duplications. Large messages can be delivered but is constrained by message size limits imposed by the network layer.

3

Network

Controls the way data will be sent to recipient ; Factors like the physical path the data should take based  etc are performed by this layer. This layer translates logical addresses, or names, into physical addresses, performs routing

2

Data Link

Handles the transfer of data across the network ; It  establishes and terminates the logical link between two nodes.

1

Physical

The lowest layer of the OSI  is generally concerned with the transfer of data medium like optical or electrical medium etc.

 

Okay back to post now, the bold part above.

Session Data Unit(SDU) is the session layer responsible for  sending/receiving data from transport layer.  See table below for OSI diagram. Generally increasing the value of SDU can result in improved performance, efficient network utilization when transmitting large amounts of data. 

However until Oracle 11g  the SDU size was limited  to 64K. Starting with Oracle12c, support for  SDU  is increased to 2M thereby allowing efficient use of  high bandwidth network.

Very useful in dataguard environments where you have network bandwidth issues.

SDU can be set at  database level by configuring DEFAULT_SDU_SIZE parameter in sqlnet.ora or SDU listener.ora parameter. On the client size SDU can set be by configuring DEFAULT_SDU_SIZE parameter in client sqlnet.ora or SDU tnsnames.ora parameter.

Comments are closed.