RE: Materialized Views 9i vs 10g

Refresh drags.....building the materialized views is not an issue...when I look 
at v$session_longops....the statistics is way longer than what I would 
expect.....

From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Thursday, August 19, 2010 10:59 AM
To: Chuck Boddy
Cc: oracle-l
Subject: Re: Materialized Views 9i vs 10g


On Thu, Aug 19, 2010 at 8:47 AM, Chuck Boddy 
<Chuck.Boddy@xxxxxxxxxxxxxxx<mailto: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: