Re: Oracle & CPU time

From: Howard J. Rogers <howardjr_at_www.com>
Date: Mon, 11 Sep 2000 23:08:05 +1000
Message-ID: <39bccad3@news.iprimus.com.au>

Never tried this myself (and with good reason), but you could see what calling up Task Manager does (ctrl+alt+delete), and switching to the Processes tab.

In Windows 2000 you can then right-click any given process and alter its priority. I know you could do this in NT 4 as well, and I seem to recall that the right-click worked there too, but my memory may be playing tricks. If it's not a right-click, hunt around in Help for details on how to set process priority.

Try lowering the priority of the Oracle processes and seeing what that does for you.

Personally, I suspect that at best you will have a sluggish Oracle database, but who knows. Fiddle around enough, and something might come good.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<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.

Received on Mon Sep 11 2000 - 08:08:05 CDT