| queries [message #365413] |
Wed, 06 May 1998 14:41  |
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  |
Frank Naude
Messages: 4590
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 |
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??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
