Re: Materialized Views 9i vs 10g
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Chuck.Boddy@xxxxxxxxxxxxxxx
- Date: Thu, 19 Aug 2010 10:58:48 -0700
On Thu, Aug 19, 2010 at 8:47 AM, Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>wrote:
> Hi,
> I am taking Materialized Views that were initially built on a 9i database
> and rebuilding them on a 10g database – verbatim. I am noticing that the
> performance is noticeably degraded. Checked out the Explain Plan on 9i vs
> 10g for some the materialized views, and they would indicate that on 10g,
> the materialized views should at least perform the same OR performance
> should be approved. Any ideas would be appreciated.
>
>
>
What does performance mean?
Too long to apply changes?
Too long to select?
etc, etc, etc.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
