queries [message #365413] |
Wed, 06 May 1998 14:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Terri
Messages: 2 Registered: May 1998
|
Junior Member |
|
|
We have an RDB database and we are sending the information into oracle 7.3, this is running under windows NT4.0. All queries run fine, except the one's that are doing year-to-date calculations. These run fine sometimes and sometimes they take about 90% of the CPU's processor, then they just hang. I've tried rewritting the codes and we still have this intermittent problem.
Please help!!!
|
|
|
Re: queries [message #365423 is a reply to message #365413] |
Mon, 11 May 1998 09:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank Naude
Messages: 4579 Registered: April 1998
|
Senior Member |
|
|
Windows/NT machines can sometimes get extremely slow when there is a memory shortage. Make sure you do not run out of memory resources.
Cheers
Frank
|
|
|
Re: queries [message #365727 is a reply to message #365423] |
Fri, 19 November 1999 07:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
woudy
Messages: 1 Registered: November 1999
|
Junior Member |
|
|
I have a similar problem with Oracle8 on NT
Memory usage is fine? but CPU gets up to 100% for
a while, if i wait long.... enough i get results and CPU drops back to low levels??
|
|
|