On Oct 22, 11:05 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <zigzag..._at_yahoo.com> schreef in berichtnews: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- Hide quoted text -
>
> - Show quoted text -
Virus scan was the first thing we looked at, it did not make any
difference.
Received on Mon Oct 22 2007 - 11:14:23 CDT
