Re: Oracle 9i performance problems ?

Hi Oded,

Most likely you have installed some Oracle related services and configured them to start automatically. Go to Control Panel->Services and shut down some of the Oracle Services to see if that releases some resources. Pay special attention to services with names like "OracleService<Database-SID>", those are database services and may consume many resources.

Especially, if you have created a new database with DBCA, it may have configured the database server with a over-sized SGA. It should not, as a rule of thumb, exceed 1/3 of your physical memory.

• Kenneth Koenraadt

On Fri, 30 Aug 2002 15:50:50 GMT, "Oded Dror" <odeddror_at_cox.net> wrote:

>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
>
>
Received on Fri Aug 30 2002 - 13:23:50 CDT