Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i performance problems ?
Your SGA seems to be too big to fit in available RAM, thus you get
excessive paging which obviously slows down your system. Additionally,
you have only one disk - this doesn't help performance either.
Reduce Oracle memory requirements so that it fits completely into
those 384 megs or add more RAM to your system (preferred, since
memory is really cheap these days). Virtual memory is what it is -
virtual - and involves paging out to disk if everything doesn't fit into
physical RAM. Since Oracle attempts to cache data it reads from disk in
RAM, and it effectively gets paged back to disk because there's not
enough physical memory to fit cached data and shared pool - no
wonder your system grinds to halt...
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Oded Dror" <odeddror_at_cox.net> wrote in message news:uvMb9.27902$Or1.1639905_at_news2.east.cox.net...Received on Fri Aug 30 2002 - 13:30:16 CDT
> Hi there,
>
> I'm using Windows 2000 Server (one member - via cable modem at home)
> My server run with 384 MB RAM
> Mem Usage 100000 of 943612
> Processes 33 (Including IIS 5.0)
> HD 40GIG ( 30GIG free)
>
> Performance Option - Optimize performance for : Backgroung Services
> Virtual Memory : Total paging file size 576MB initial 1152 MAX
> Registry 20MB 55MB Max
>
> After I installed Oracle 9i Server ( 9.2010 Release ) I'm getting very very
> slow performance
> the computer run very slow
>
> Mem Usage : 427700 of 943612 ( almost 50%)
> Processes 47 (some times 50)
>
> How do I solve this problems ?
>
> Thanks,
>
> Oded Dror
>
>