RE: SQL*Net waits in a 10046 trace

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Wed, 23 May 2007 16:20:38 -0400
Message-ID: <6591F529444E9748A546718B3D1A67010701A575@xcgv2605.northgrum.com>

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_at_ons.gsi.gov.uk] 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

Received on Wed May 23 2007 - 15:20:38 CDT