Re: Strange behavior on NT

What NT service pack are you running?
We had a similar problem when we upgraded to SP4, and going back to SP3 fixed our problem. In our case, we experienced a constant, gradual decrease in performance for a batch type operation (where we ran a task that pegged the CPU but only for a few seconds). As time went on, the task took longer and longer. If your application has the CPU chugging away constantly, then after some time, the CPU would be pegged all the time. In that case, you may be experienceing the same problem we did. anyway, post back if you find any insights.

Dave

EBR <11eebr13_at_hotmail.com> wrote in message <371f2324.649878_at_news.newsguy.com>...
>Hi,
>
>I would like to get any suggestions on a strange problem that's
>happening with us.
>
>We have a large database with about 200,000 new records a day. It's
>working fine, except for a strange behavior that happens after some
>hours of processing (about 12, I observed). The CPU gets 100% and
>don't get down again.
>
>The machine gets slower and we have to shutdown the database. After
>that, everything becomes fine again.
>
>Our hardware configuration
>
>- Pentium II 333mhz
>- 512mb RAM
>- 15GB in a disk array
>
>Our Oracle Configuration:
>
>- Oracle 8.0.5 enterprise edition
>- 2.5gb on a roll_back tablespace with a pool of five segments, 500mb
>each
>- 4 redo log groups with the default configuration
>- Database archive off
>
>Thanks in advance for any suggestions,
>
>EBR
>
>EBR
>** Please remove the primes to get my real e-mail
Received on Mon Apr 26 1999 - 23:00:48 CDT