Do you have any large temp tablespaces? I have run into issues with sort
segment deallocation sucking up all CPU cycles, and on a big sort space it
can take hours. We have mitigated it by creating 4meg extents in the temp
tablespace...it still brings things to a crawl when the deallocate, it just
takes less time.
-Eric Bowman-
"Tom Brown" <tom_at_eazyriders.com> wrote in message
news:AUNl8.3567$MQ2.27571346_at_news-text.cableinet.net...
> Hi,
>
> We have a Win2k machine running 8.1.7 with 2 instances on it. Up untill
> today everything was fine but then one of the instances started to utilize
> 100% CPU. Even by stopping all processes the CPU load did not reduce. In
the
> end i rebooted the box but as soon as this instance is started the same
> thing happens 100% CPU and the box basically locks up but you can still
> execute SQL commands from a terminal.
>
> Does anyone know why this might be as i've looked everywhere i can and
can't
> seem to find the answer.
>
> thanks
>
> Tom
>
>
Received on Sat Mar 23 2002 - 13:52:09 CST
