Re: Oracle & CPU time

If your NT server has multiple CPU you can reduce the number of used CPU with the CPU_COUNT parameter.

ie: Machine with 3 CPUs: set CPU_COUNT=2 this way it will garanty your other running processes some CPU time if Oracle is not running alone on your machine.

Guy Boulais
OCP DBA (7+8) In article <9tYu5.57413$e11.441780_at_news1.rdc1.nj.home.com>,   "SANDEEP JAIN" <sandeepti_at_home.com> wrote:
> Memory Usage can be controlled using Init.ora parameters.
> Control over CPU resources may not be straighforward in NT
>
> Sandeep
>
> <kkannan9451_at_my-deja.com> wrote in message
> news:8phfir$tvv$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I have installed oracle 8.1.6 database server on an NT
> > server 4.0 (sp 6). I am using the same server for other
> > activities as well. But when processing, oracle eats
> > up most of resources making the other processes starve
> > for CPU time... This gets pretty annoying when oracle
> > processes some complex enuff. Is there any way I can
> > slow the oracle process down (since it is not time
> > critical) and make it use lesser memory?
> >
> > Would appreciate any help in this regard.
> >
> > Thanks
> > Karthik
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 11 2000 - 15:29:25 CDT