dakshin wrote:You should be fine.
Due to a 3rd party application's requirement, I may be forced to use 32-bit client of Oracle 10gR2 on the application server to connect to a 64-bit DB server (another box). The OS is SUSE Linux ver 10. Platform is x86.
- Does this result in performance degradation? Does Oracle has any recommendations about this kind of scenerio? Searched the net without much gain.
Please help. Thanks.
I may be forced to use 32-bit client of Oracle 10gR2 on the application server to connect to a 64-bit DB serverI don't see your DB Server version.
dakshin wrote:I suspect there might be performance issues if you attempted to send a 2GB packet. ;-)
Question is: Does this have any disadvantages / performance problems? Are there any recommendations from Oracle?
dakshin wrote:Not by any use of the software that I can imagine. Network packets are typically limited to under 1 MB (under 16K) in any case, so you never pass the 32-bit need from a networking side.
Thanks for the reply.
1.Will the response time at the application server be better if I could use a 64-bit client?
2. 2^32=4GB; Will the 32-bit client be constrained to access data sets of maximum 4 GB at a time?