How can you set the package size to certain value on your tnsnames/listener. we have some problem with the network and one of the suggestion is trying to set the package size to 8192
any advises???
How can you set the package size to certain value on your tnsnames/listener. we have some problem with the network and one of the suggestion is trying to set the package size to 8192
any advises???
go to network admin guide index, look SDU and TDU
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
I have a question about this issue and it's still a mysteries, could someone throw out some hint.
We have a procedure on our client database, it access to our database through DB Link, basically the proc go to our database and grab the data and pull it to their database do some business logic and update some of the records on our database. The two tables on our side is not big (<100 rows). For some reason, every time the procedure was executed, it froze. After some analysis, the DBA requested to do SQL* trace during the execution of the proc.
Is his approach is appropriate??? Could anyone think of the reason??? BTW, my database and the client database was connected via fiber optics. could it be the firewall set up or configuration????