Re: A couple of questions

"MK" <MK_at_foo.com> wrote in message news:bingco$92uqo$1_at_ID-174077.news.uni-berlin.de...
> 1) when I export with indexes=y, and then import the resulting
> dmp file into another instance (also with indexes=y), are
> indexes imported, or rebuilt from ground-up?

indexes are always re-created in an import.

>
> 2) how can I throttle CPU usage for oracle.exe? During
> the night I run various DML jobs (mostly DELETE statements)
> and those jobs run oracle.exe up to 100%. This suffocates
> other processes on the machine and I get all kinds of
> warning messages. I'd like to put a limit, for example
> 80%, on oracle.exe's CPU usage - would this be possible?
>
> Oracle8i on W2K.

Upgrade to 9i. There is a nice resource manager in 9i that will allow you to smoothly run the system. It exists in a rudimentary form in 8i, so I don't know if it will help.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam