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

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

.

Relevant Pages

  • Re: Need in-depth help with usage analysis processing
    ... In your configuration database Sites table what is the value of the URLPath ... looked at the site usage report and indeed it updated. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Database Performance Problem between 3:00PM and 4:00PM
    ... where by database becomes extremely slow between 3:00PM and 4:00PM. ... FRom the beginning we suspected Network to be an issue, ... monitoring cpu, disk, memory usage..), do n''t see anything different ...
    (comp.databases.oracle.server)
  • Re: Database Performance Problem between 3:00PM and 4:00PM
    ... where by database becomes extremely slow between 3:00PM and 4:00PM. ... FRom the beginning we suspected Network to be an issue, ... monitoring cpu, disk, memory usage..), do n''t see anything different ...
    (comp.databases.oracle.server)
  • Re: Database Performance Problem between 3:00PM and 4:00PM
    ... where by database becomes extremely slow between 3:00PM and 4:00PM. ... our Networking departament, They monitored Network, could not find any ... monitoring cpu, disk, memory usage..), do n''t see anything different ...
    (comp.databases.oracle.server)
  • Re: Database Performance Problem between 3:00PM and 4:00PM
    ... where by database becomes extremely slow between 3:00PM and 4:00PM. ... broadcasting a Christian radio show at 9PM every night, overwhelming ... door would turn on large machines at particular times, affecting ...
    (comp.databases.oracle.server)