Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Performance Problem between 3:00PM and 4:00PM

Re: Database Performance Problem between 3:00PM and 4:00PM

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 22 Oct 2007 17:05:05 +0200
Message-ID: <471cbc29$0$229$e4fe514c@news.xs4all.nl>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US