Oracle Over DigiNet

mavx

Well-Known Member
Joined
Apr 20, 2005
Messages
338
Reaction score
3
Location
Kzn
We currently run our Oracle Database to other offices via DigiNet lines. We seem to have a problem on and off with speed and response times. We use the same line for Internet and mail retreival from our internal server and intranet.Can anyone tell me

a) What kind of load do Oracle forms and reports put on a line?

b) As a rule of thumb, how many users in this type of enviroment would a 64k line support, realistically, not Telkom specifics!

c) What kind of one-way Satellite solutions are available these days in South Africa ?
 
Hmmm, these kind of questions are what we get paid a lot of money to come and ascertain for clients.

Question c) I cant answer for you with any degree of accuracy.

The others kind of go hand in hand. While I havent done much work on slow connections using SQLNet, there is no really quick answer. The short answer is that Oracle applications tend to be quite network intensive and can very easily eat up whatever bandwidth you give it.
That said, careful design of the application can minimise network traffic substantially. Trying to get fetch as little data as possible down the pipe is obviously beneficial, and if the application is designed to get the database server to do as much of the work as possible and then bring back as small data sets as possible, you should see some benefits. Use stored procedures to do more remote work.
Other things to consider, try do some reading up on SQLNet configuration. I think there are some settings which try and optimize the way SQLNet applications talk to each other.
Also, do some tests to see if building an application web server (IAS) might help. Its a middle tier that can sit behind the slow connections, usually on the database server, or on a machine on the same high speed network. The benefit here (though not always) is that all Oracle Forms and Reports processing is done on the webserver, and only relevent display information is sent to your web browser, thereby minimizing network traffic on the slow connection.

The number of people who can share these type of applications across a single 64Kbit link varies, and the answer lies more on the pessimistic side, unfortunately. Nevertheless, factors like how often people are actually fetching across the link, the size of the fetches and how many people are hitting it simultaneously naturally affect the final answer. But dont get too excited, I dont think that you will get too many people on a 64K link. 5 concurrent without people getting too frustrated is very optimistic. But this number could go up to 20+ if the app is small and there is only sporadic work being done. Do lots of tests first and try and have them emulate as close as possible to your real life situation.

Sorry - this reply might seem quite long, but it is in fact very brief. It might give you some food for thought and some ideas to check up. But a write up here is not going to ultimately going get you an answer.
 
Last edited:
The Oracle database environment is real biatch and an absolute disaster from an efficiency point of view, made many more times inefficient by front-ends written in Forms / Reports / Developer / Discoverer without this in mind, and compounded even further by their Applications environment. It's 'popularity' is a consequence of its marketing effort, much like M$. If I were you, I'd actively promote the initiation of a project designed to look at alternatives with better all-round efficacy...
 
A 64k diginet line does not scale very well for internet and email, throw Oracle into the equation and the picture is not pretty. Why not use ADSL and VPN's ?
 
mavx said:
We currently run our Oracle Database to other offices via DigiNet lines. We seem to have a problem on and off with speed and response times. We use the same line for Internet and mail retreival from our internal server and intranet.Can anyone tell me

a) What kind of load do Oracle forms and reports put on a line?

b) As a rule of thumb, how many users in this type of enviroment would a 64k line support, realistically, not Telkom specifics!

c) What kind of one-way Satellite solutions are available these days in South Africa ?

Hi
Quick question - are you using an Oracle application (like Oracle Financials) or is it a custom application developed on top of an Oracle Database? If its Oracle Financials, it will be very thin on the line (similar to SAP R/3 - its also a true 3 tier system), and you should be able to get the exact line sizing via the Oracle OSS.
Also, Oracle financials does not work well over Satellite - the latency is too high...
Cheers ~
ScrnScrm
 
Thanks for the replies, heres some answers to the questions posed:

Looking for an alternative is a no-no, the system is in place and training has been done etc. Using ADSL would be great, some of the offices are too far away from the exchange, we have to use Radio Links for the last mile in some places! It is a custom designed system on top of Oracle with a reporting protal we use aswell. Just wish Telkom would provide us with more alternatives! Would love to have a 1mb line from office to office!!
 
mavx said:
Looking for an alternative is a no-no, the system is in place and training has been done etc.

I do not want to be a pessimist and do not know enough about Oracle to say anything specific about that, but I have seen many cases where applications were developed and tested on a LAN and everything worked great. However, they then failed on a WAN, since the WAN simply did not have the capacity of the LAN.

Especially clients where raw data is taken from the database and processed on the client side runs into these kinds of problems. For example, in a 100Mbit Lan, if a client application pulls 0.5MB of data from the database, nobody will probably notice. If the same happens on the 64K line, it is a disaster.
 
I dont know what your budget is, and I also cant guarantee its effectiveness, but one of our major retail clients use Citrix at all their remote store sites, and they run on 64Kbit lines. The Oracle app sits at the head office and a manager at each store has access to connect to the remote server. This piece of information for free after several months of initial tests a few years ago found that IAS didnt perform quite as well as the Citrix solution did. It's not fast, but as much as I hate Citrix (or any other Windows apps for that matter) it was at least useable. But Citrix linces also cost a bundle (but again, that might be because they're a major business).

But in your tests, benchmark it against IAS as well, you might find your app is reasonably well written that its performance is acceptable. Just dont expect lightning speeds though.
 
The slow downs you have are probably big emails being sent or received, or some download going on. Your not likely to solve the problem unless you throttle the email and internet, but that's going to make them unusable. Some kind of change or upgrade is very likely the only way you are going to fix it. Upgrading the Diginets from 64k to 128k may do the trick, but not very cost effective.
What about giving the branches ADSL for browsing and email, and leaving your Oracle connections on the Diginet?
 
asmith makes a very valid point - you should first have a look at the nature and volume of the traffic involved, and then based on the sizings concerned, consider appropriate solutions. You may even achieve substantial improvements just by implementing an appropriate usage policy, or simple traffic management, or a QoS box, if you haven't yet looked at these mechanisms...
 
Whew ok, I can well imagine that there are many other establishments out there that have or are experiencing the same frustration! I've been monitoring the traffic on our firewall, there doesnt seem to be much private use or abuse of the traffic, theres the odd personal website that comes up but most of the traffic is Oracle related. As far as I can tell the router is Cisco 7206, from what I gather it's a pretty ancient model. At the remote sites we also have Cisco routers, 2905 series. We dont have the facility for port shaping on the older model, hence we cant thottle back the personal usage if that was a problem! We are currently in the process of upping the line to 128, it should solve a few of speed issues but we have more remote sites to look after.
 
Top
Sign up to the MyBroadband newsletter
X