RE: SQL*Net waits in a 10046 trace
- From: "Schauss, Peter" <peter.schauss@xxxxxxx>
- To: "Ian Cary" <Ian.Cary@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 May 2007 16:20:38 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
