ciatecmx
23rd August 2007, 02:59
My subject may not be related to Baan directly, I am trying to solve the slowness of the system.
I have Baan 5c and Oracle 10g R2 on the AIX 5.3 server. Because of the slowness of response between Baan and Oracle, I checked on the wait_session of the Oracle and found a lot of "SQL*Net message from client" in Idle and Network. If I just run the query that Baan submited insides the Oracle, all explain plan showed clean and quick. so I suspect that the processs of Baan pass some large size message, including the query scripts to Oracle and the network has bottleneck problem. I checked on my network set up (hardware) part, and found this
#pmtu display (an AIX command)
dst gw If pmtu refcnt redisc_t exp
----------------------------------------------------------------------
10.10.1.30 127.0.0.1 lo0 16896 23 11 0
10.10.3.2 10.10.1.30 en0 1500 1 0 0
127.0.0.1 127.0.0.1 lo0 16896 2 11 0
If you have the similar setup, what is your?
Talked to our network eng. He told me that our network can not configure the MTU higher than 1500 bytes to avoid the drop of package.
I have Baan 5c and Oracle 10g R2 on the AIX 5.3 server. Because of the slowness of response between Baan and Oracle, I checked on the wait_session of the Oracle and found a lot of "SQL*Net message from client" in Idle and Network. If I just run the query that Baan submited insides the Oracle, all explain plan showed clean and quick. so I suspect that the processs of Baan pass some large size message, including the query scripts to Oracle and the network has bottleneck problem. I checked on my network set up (hardware) part, and found this
#pmtu display (an AIX command)
dst gw If pmtu refcnt redisc_t exp
----------------------------------------------------------------------
10.10.1.30 127.0.0.1 lo0 16896 23 11 0
10.10.3.2 10.10.1.30 en0 1500 1 0 0
127.0.0.1 127.0.0.1 lo0 16896 2 11 0
If you have the similar setup, what is your?
Talked to our network eng. He told me that our network can not configure the MTU higher than 1500 bytes to avoid the drop of package.