RE: SQL*Net waits in a 10046 trace

Thanks Ian.  With this change, our application login times went down
from 1 minute to 7 seconds.

Thanks,
Peter Schauss

-----Original Message-----
From: Ian Cary [mailto:Ian.Cary@xxxxxxxxxxxxxx] 
Sent: Wednesday, May 23, 2007 10:21 AM
To: Schauss, Peter
Subject: RE: SQL*Net waits in a 10046 trace


It might be worth changing the SQL*Net packet size to see if that
improves
your blob performance. To do this you need to change the listener.ora
listening to instance to say

    (SID_DESC =
      (SDU = 32768)
      (TDU = 32768)
      (SID_NAME = <your instance>)
      (ORACLE_HOME = <your Oracle home>)
    )

You also have to change the tnsnames.ora alias used to connect to the
instance to match e.g.

<Your TNS Alias> =
(DESCRIPTION =
    (SDU = 32768)
    (TDU = 32768)
    (ADDRESS_LIST =
...........

For large blobs these settings can improve network performance as the
increased packet size will reduce network round trips. The downside is
that
the there may be a detrimental effect on "ordinary operations" due the
packet size being larger than required.

Cheers,

Ian



For the latest data on the economy and society consult National
Statistics at http://www.statistics.gov.uk

************************************************************************
*********


Please Note:  Incoming and outgoing email messages are routinely
monitored for compliance with our policy on the use of electronic
communications
************************************************************************
*********


Legal Disclaimer  :  Any views expressed by the sender of this message
are not necessarily those of the Office for National Statistics
************************************************************************
*********


The original of this email was scanned for viruses by the Government
Secure Intranet Anti-Virus service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2006/04/0007.) On
leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: