Re: Mviews Refresh Timings
From: <gareth_at_jamms.org>
Date: Mon, 9 Mar 2009 05:23:52 -0700 (PDT)
Message-ID: <898be11f-b6fe-42be-b947-d05c07240220_at_q27g2000vbn.googlegroups.com>
On 8 Mar, 22:06, "lyx..._at_gmail.com" <lyx..._at_gmail.com> wrote:
> Hi All,
>
> 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.
>
> Regards,
Date: Mon, 9 Mar 2009 05:23:52 -0700 (PDT)
Message-ID: <898be11f-b6fe-42be-b947-d05c07240220_at_q27g2000vbn.googlegroups.com>
On 8 Mar, 22:06, "lyx..._at_gmail.com" <lyx..._at_gmail.com> wrote:
> Hi All,
>
> 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.
>
> Regards,
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1105.htm#i1582466
HTH -g Received on Mon Mar 09 2009 - 07:23:52 CDT