Re: oRACLE 9Ias

Martin Hopkins wrote:
> Could you please help with this enquiry.
>
> We have just installed Oracle 9iAs Release 2 onto Nt4 SP6a servers.
Does that work?!?
> One sever is the Domain PDC with the database installed,

Ouch! Bad decision - a database server is a database server is a db server.
> 2nd server is the BDC with Apps installed

Again, ouch!
> and the 3rd servere is the Infra structure server, with
> DNs installed.

And again.

>
> However runing the Oracle Application is very very slow!! We are advised the
> network speed of 10MB/sec is the reason and we require 100Mb/sec. As all
> other networks in the area are 10 MB/sec with 1000's of users I am spetical
> of the requirement to upgrade to 100MB/sec.

OK, let's do some simple math...
Assumptions:
1) Apps will only create HTML - no jars, applets or similar stuff flying around.

2) the average html page is 20 kb (kilo Bytes!)
3) an average apps session will open/use 4 pages at a time.
4) your desired response time is 2 secs or better

20 kb * 4 = 80 kb; in 2 seconds, is 40 kb/sec. There's some overhead in TCP/IP, so let's make 1 Byte = 10 bits.

That's 400kbps. You have a 10Mbps network. Ethernet will deteriorate with about 40% bandwidth used, so you need to be sure no more than 4Mbps is transferred at any time. Anything more, and you will see collisions, resends, etc. 4Mbps/400kbps = 10 users... (Concurrent, that is).

You have 1000's of users? Back to you to do the math.

>
> The database was built with 500MB Datafiles and 100MB redo logs which seems
> very learge compared to our Oracle 8 database. Is this causing problems.

No - your main problem is you have no clue what causes the slow responses. Been looking closely at your servers lately? I would take a look at the database to start with - it's probably congested with sessions (OS level) being opened/closed. Check with netstat (does that work on NT? It does on w2k); you will probably see many "closed waiting" sessions.

If so, switch to MTS.
For the rest - not enough details.

-- 
Regards, Frank van Bortel