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: Wed, 07 Nov 2007 07:50:22 +0100
Message-ID: <47315f84$0$29371$4c56b896@news-read1.lambdanet.net>


NetComrade wrote:
> On Sun, 04 Nov 2007 11:38:47 -0800, DA Morgan <damorgan_at_psoug.org>
> wrote:
>

>> Jan Krueger wrote:
>>
>>>> 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
>> I agree. SOP is to point the finger elsewhere. Ask them what metrics
>> they gathered that support their conclusion.

>
>
> Ask them to enable SNMP on the array and how IO patterns for the
> night. Find out what else is on the SAN.. if they insist there are no
> problems, tell them you want a dedicated SAN :)
>
> This is likely some backup job.
>
> -a
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
> remove NSPAM to email

No no, just get two SQL trace files. Don't look somewhere else than in the db. Once you got the information from the trace that storage access is causing the difference, bother the other department.

Jan Received on Wed Nov 07 2007 - 00:50:22 CST

Original text of this message

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