On 25 Oct, 22:07, zigzag..._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?- Hide quoted text -
>
> - Show quoted text -
Did you try my suggestion of monitoring V$SESSION during the period in
question?
Received on Fri Oct 26 2007 - 04:32:24 CDT
