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

On Oct 22, 3:56 pm, zigzag..._at_yahoo.com wrote:
> 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.

You've kicked all the users off, you've made sure that no job's are running, v$session is basically empty and the os shows no difference? If so I'd be beginning to wonder (if you haven't missed something above :( ) if you are using some sort of shared storage or a relatively low bandwidth network and the culprit is a scheduled job that utilises the same scarce resource, but from another server.

If the issue starts precisely at 3 you'll win money betting on a scheduled task somewhere in the estate - people aren't that regular. Received on Wed Oct 24 2007 - 10:08:17 CDT