Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Performance Problem between 3:00PM and 4:00PM
<zigzagdna_at_yahoo.com> schreef in bericht
news:1193064977.148736.166830_at_i38g2000prf.googlegroups.com...
>I am Windows 2000 server using Oracle 9.2.0.6. We have strange problem
> where by database becomes extremely slow between 3:00PM and 4:00PM.
> Same queries which take 15 seconds before 3:00PM (e.g., 2:55PM) take
> 3-4 minutes at 3:00PM and after that. Poblem starts right at 3:00PM
> every day. No of users etc are same. We have asked users not to use
> the system during that period for isolating performance problem,
> without any success.
>
> When one looks at CPU Usage, Memory Usage and Disk Usage nothing
> changes between 2:55PM and (3:00PM-4:00PM). I kooked at task mgr, no
> new processes. I have looked at Windows scheduler, Oracle dbms_job.
> Nothing is running between 3:00PM-4:00PM. I have no clue why system
> becomes so slow in that period. I was hoping that some job starts at
> that time, but cannot find any. Any ideas for troubleshooting will be
> appreciated.
>
McAfee? Virus scanners? People starting playing games? Network problems?
Shakespeare Received on Mon Oct 22 2007 - 10:05:05 CDT
![]() |
![]() |