Re: Mviews Refresh Timings
Date: Sun, 8 Mar 2009 17:06:33 -0700 (PDT)
Message-ID: <26a55f26-eb8b-4ef4-8b3c-659a49a91f50_at_p20g2000yqi.googlegroups.com>
On Mar 8, 7:52 pm, Palooka <nob..._at_nowhere.com> wrote:
snip
> > We have production box on 10g R2 on Linux system. One Mview refresh
> > job which refreshes bunch
> > of mviews takes normally 10 hours. It is 3 TB database. But sometime
> > this jobs take 15 hours or more.
>
> > I agree that this should look from performance tuning prospective but
> > at this time I am looking for idea to track the speed of this refresh.
>
> > The jobs which refresh is one Oracle Seeded program which I can not
> > edited. Is there a way to know how much time it spends in refreshing
> > one particular Mview.
>
> > So, that I can trace down that this Mview is taking much time than un-
> > usual. I would also note down some timing baselines.
>
> > I could not find this straight forward view for this. View got timings
> > when it was last refreshed.
>
> > Your reply would be appreciated. I am looking for which mview is
> > being refreshed curently and when it started and completed.
>
> Easy.
>
> Hire a competent DBA.
One choice is always to just scroll on by if you don't feel like taking a stab at helping someone.
It pays the same either way. Received on Sun Mar 08 2009 - 19:06:33 CDT