how to set packages size to certain values on your tnsnames/listerner

[tamilselvan]

In the listener,

SID_LIST_LISTENERABC =
(SID_LIST =
(SID_DESC =
(SDU = 8192)
(TDU = 8192)
(SID_NAME = ABC)
(ORACLE_HOME = /opt/app/oracle/product/9.2.0)
)
)


In the tnsnames.ora,


ABC =
(DESCRIPTION =
(SDU = 8192)
(TDU = 8192)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.100.100.100)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ABC)
)
)

Tamil