Re: Oracle 9iAS Infrastructure & Application

Martin Hopkins wrote:
> We have had Oracle 9iAs version 2 installed over 3 servers:
>
> 1 - Database, 2- Application & 3 - Infrastructure
>
> They are Dell 2650 Servers with 1GB Mem and running Windows Nt4 SP6a over a
> 10MB/s network

I recall a previous post about slow oracle performance on a 10MB/s network, the reason was the network. How many people are connecting to this? The other post said the database got slow as more people connected, I don't recall the formula given for bandwidth per user, but there was one. Just looking at the formula, the reason for the slow performance was very obvious...just the numbers showed a slow performance very clearly.

My point is, I'd take a look at the network.... Also, what steps have you done for documenting/measuring/benchmarking this setup? What performance stats do you have? Do you have any? If you had done the basics of measuring the performance, you'd have a better idea of where your bottle-neck is occurring. It's funny, they tell you in college to document and benchmark all your work....but I've yet to go to a site where they have accurately documented and benchmarked their IT setup! It's a mad world out there!

>
> But the application / reports etc runs very slowly.
>
> Should the Infrastructure and Application servers reside on ONE Server for
> better / faster results.
>
> The servers have been set up with a 2GB Swap file (FAT), is this enough for
> Oracle? Or is morew temp space required within the database structure?
>
> Thank yuo any help on this matter.
>
>
Received on Sat Apr 05 2003 - 21:09:35 CST