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

On 22 Oct, 15:56, 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.

The most likely explanation is that something else is running against the database between those times. Note: this process need not originate from the database server itself, hence nothing in Task Manager, Scheduled Tasks and DBA_JOBS.

Monitor V$SESSION for any suspect sessions.

HTH -g Received on Mon Oct 22 2007 - 10:12:46 CDT