What is exactly version of windows 2000 you are using?
Have you tuned your OS to use so called 4GB tunning?
Sugested link:
http://www.microsoft.com/windows2000/en/advanced/help/default.asp?url=/
Title Enterprise memory architecture.
Użytkownik "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> napisał w wiadomości
news:uet1ecr07qlb1d_at_corp.supernews.com...
>
> "Chuck" <ccarson_at_syrrx.com> wrote in message
> news:3CEE78B1.2070301_at_syrrx.com...
> >
> > We have a Compaq cluster (each node is 3x cpu and 8 gig RAM). I am the
> > Unix guy and am no expert on Windows but have 3yrs as an Oracle DBA on
> > Solaris and Linux. They are having performance problems with a VB
> > application that updates a single column of a table which in turn fires
> > three triggers that insert/update three other tables.
> >
> > The cpu's never get taxed, staying at about 15% util. Oracle's mem usage
> > is stuck at 1.6 gig. The systems has a total of 6x4 gig pagefiles, 4 of
> > which are on the same disk! (this was a brain stumper for me)
> >
> > I guess my questions are, what is the max memory usage for Oracle on
> > this kind of config? Also, it makes sense to me that one 4 gig pagefile
> > would be faster than thrashing accross 4 on the same disk? Also, it
> > makes sense to me that a properly configured system/database/application
> > should never use swap at all (is this far fetched)? The disk subsystem
> > is hardware RAID 5 (I know another performance hit) split into 4 raid
> > paritions. I am pretty sure that the datafiles being on Raid 5 is not
> > the bottleneck in this case (although it should be which is why
> > something else is defintely not right)
> >
> > Lastly, I noticed a large number of page faults for ALL processes
> > runninig on the system, not just Oracle.
> >
> > The system is not doing a very large number of transactions it is taking
> > data from two large robots that take pictures of biotech experiments
> > (small 96 well trays), at most, it make get 2 requests per 2 seconds.
> >
> > Can anyone give this Unix guy some Oracle on Windows pointers?
> >
> > Thanks,
> > Chuck
> >
> >
> >
> >
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> ==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> =-----
>
>
> I am pretty sure that the datafiles being on Raid 5 is not
> > the bottleneck in this case
> What makes you say this? Did you actually run perfmon to monitor the
> diskqueue length?
> Also does the RAID-5 array include the pagefile.
> I'm pretty sure redologging needs to be tuned, people with VB-Sqlserver
> expertise always ignore that?
>
> Also, you need to check whether the server service (in the network applet
in
> control panel) has been set to optimize for network applications.
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Sun May 26 2002 - 18:04:29 CDT
