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: <zigzagdna_at_yahoo.com>
Date: Tue, 11 Dec 2007 19:18:20 -0800 (PST)
Message-ID: <f82c64ba-d664-459d-8b62-4bc8875cffd3@b1g2000pra.googlegroups.com>


On Nov 7, 1:50 am, Jan Krueger <j..._at_stud.uni-hannover.de> wrote:
> NetComrade wrote:
> > On Sun, 04 Nov 2007 11:38:47 -0800, DA Morgan <damor..._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- Hide quoted text -
>
> - Show quoted text -

We have finally nailed down this problem. It is something in SAN. When we moved database from SAN to local disk on Windows server, problem went away. I had never heard eralier that problem in SAN can happen certian time of day, really strange. Received on Tue Dec 11 2007 - 21:18:20 CST

Original text of this message

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