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: Jan Krueger <jk_at_stud.uni-hannover.de>
Date: Sun, 04 Nov 2007 18:29:44 +0100
Message-ID: <472e00e0$0$29370$4c56b896@news-read1.lambdanet.net>


zigzagdna_at_yahoo.com wrote:

> On Oct 25, 5:05 pm, Niall Litchfield <niall.litchfi..._at_dial.pipex.com>
> wrote:

>> zigzag..._at_yahoo.com wrote:
>>> No Oracle backup jobs or database statistics run at that time. SAN is
>>> used for disks. I have to check details of SAN with storage group. I
>>> will look into Filemon, but I have been using Windows perfmon which
>>> lets me collect disk usage, memory usgae, cpu usage etc
>>> periodically .It is pretty nice utility.
>> So it is shared storage, I'd definitely be looking at a scheduled task
>> somewhere in the infrastructure. It does strike me as odd though,
>> especially if you say you've asked users to hold off between 3 and 4
>> that you are doing far more i/o at that time than you are just before. I
>> wonder if it turns out that there really is nothing else sharing
>> components of the san that affect these boxes, if the larger io
>> throughput is responsible for exhausting san cache. I'd still wager on a
>> scheduled task somewhere in yur infrastructure though.
>>
>> --
>> Niall Litchfield
>> Oracle DBAhttp://www.orawin.info/services
> 
> 
> I talked to my SAN team and they do not see anything wrong with SAN.
> It definteley looks like some scheduled task but no one knows what it
> is?
> 

I have never heard SAN people saying something else. Same is true for network people.

Jan Received on Sun Nov 04 2007 - 11:29:44 CST

Original text of this message

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