Oracle certifications - oracle basic question

Author

oracle basic question

wirelessboy

2003-08-04, 1:52 am

hello members

i am posting this query here, as i do not know anything in oracle, hope some oracle expert will reply this.

i have ten users for oracle running on windows PCs at a site, i have put a 64 kbps WAN link to their oracle server at another location.
is the bandwidth enough for ten users, my WAN link is getting choked, but i find nothing wrong in my link.

what is the per PC utilized bandwidth for oracle applications?

thanks

Surly

2003-08-11, 10:40 am

I know this won't be what you want to hear, but it really depends on your application. If the app pulls a lot of data from the database - or even small amounts of data very often - the response time will be poor. Some apps may even time out waiting for a response.

I'm not a programmer, but have dealt with similar issues in the past and know that many performance problems can be alleviated by tweaking the way the application requests data. In our case, we had a client/server package written in Oracle's Developer 2000 running over a WAN, and it absolutely *sucked* at first - populating data in some screens took 8-10 seconds. We finally put a protocol analyzer on it and noticed a lot of unnecessary data being pulled from the database for things like drop-down fields. Our DBA helped them clean the module up and cut about 6 seconds off the response time.

Ultimately, though, even that wasn't good enough. We wound up using Citrix Metaframe to run the app remotely, and then it was almost as good as LAN speed due to the highly optimized ICA protocol Citrix uses. This was admittedly an expensive solution, but a good one for us. Maybe you can investigate other thin-client options (Windows terminal services, pcAnywhere or even VNC).

An Oracle app is going to use SQLnet traffic (usually TCP port 1521) to interact with the database, so there's always going to be the overhead of the connection-oriented protocol. My guess is that it's going to be a little slow at 64k, but what you can tolerate depends on your app, your people and your business.

Sponsored Links