What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
COURSE of the MONTH
12 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
The server becomes at the afternoon
Posted on 2008-06-19
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.
Best regards,
SilviaLl
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.
Best regards,
SilviaLl
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2-
2
- +2
8 Comments
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!
hope that helps!
If I look the processes
the inactive is 92%
The oracle is 5%
The mcafee is 3%
I don't know. The memory???
the inactive is 92%
The oracle is 5%
The mcafee is 3%
I don't know. The memory???
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.
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.
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!
you need to be more specific about "slow." what do you mean by "slow?"
is that you cannot move your mouse or a query running again Oracle database is slow?
why is Mcafee on there?
I run 8.1.7 with a few hundred users. It runs like a dream and FAST. For 8 years, I have had 0 problem.
is that you cannot move your mouse or a query running again Oracle database is slow?
why is Mcafee on there?
I run 8.1.7 with a few hundred users. It runs like a dream and FAST. For 8 years, I have had 0 problem.
OK, that changes equation completely. you have a Oracle problem rather than a computer hardware or OS problem.
What kind of ERP are you running? When you say "locked," what do you mean? locked record?
email me if you can. i can send you some tools to diagnose.
chinabee at yahoo dot com
I would definitely remove McAfee or at least put all oracle folders under its exception list if you haven't done so.
What kind of ERP are you running? When you say "locked," what do you mean? locked record?
email me if you can. i can send you some tools to diagnose.
chinabee at yahoo dot com
I would definitely remove McAfee or at least put all oracle folders under its exception list if you haven't done so.
Featured Post
Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works.
the topics in the following article covered are,
1) dell hardware raidlevel (Perc)
2) adding HDD
3) how t…
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses
Course of the Month12 days, 13 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.