The users work fine at 8:00 a.m but in the evening 6:00 pm the system is slow.
The server:
2 CPU Xeon 3GB
3 HARD DISC 72GB U320 (RAID 5)
MEMORY 2GB
SO
Windows 2000 server
Programs
Oracle 8.1.7 ( with Archive log)
Aplication (16bits access to Oracle) The users work with this application.
Mcaffe
Performance
% Time CPU = 10
Max hard queue = 4,35
Average hard queue = 0.59
Current queue hard: 15
Server/file open= 119988
Server/logon = 5164
Max cache errors = 561.89
Max Memory errors = 11574
This server is Active Directory.
The users works fine in the morning but in the afternoon the system becomes very slow. If I restart the server then I works fine. What is the problem? There isn't the antivirus working. There isn't any Backup system working. Only the oracle works.
Check to see that there aren't any scheduled tasks running at that time. Open up task manager and look and the processes. Change the sort order to show highest memory utilization first and see what's using up all your resources.
hope that helps!
0
silviallAuthor Commented:
If I look the processes
the inactive is 92%
The oracle is 5%
The mcafee is 3%
Oracle 8.1.7 is now an old database version. Has this always been a problem or has it started recently? Is it possible that the database is suffering from a memory leak resulting in the amount of system memory being used up, the longer the database is up and being used.
Is it possible for you to check the memory usage/availability in the morning when it is first started and when it slows down in the afternoon?
Is it possible to upgrade to a later version of Oracle. I suspect the answer is no and this is probably a little drastic at this stage, until the cause of the slowdown has been determined.
0
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
Just had another thought. You mention you have archiving switched on. Is it possible the disk drives are filling up as log files are being archived? This doesn't really explain why everything is okay once the db is restarted though!
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
hope that helps!