Re: Optimizer issue in 11g
From: Randolf Geist <mahrah_at_web.de>
Date: Sat, 20 Feb 2010 01:50:54 -0800 (PST)
Message-ID: <53a06fb2-1823-47e0-bf8a-733aaaae281d_at_l19g2000yqb.googlegroups.com>
On Feb 19, 2:43 pm, amy <amykl..._at_gmail.com> wrote:
> Thanks everyone for your responses. The issue has not resurfaced after
> I posted this question. I was hoping to check out some of the
> suggestions posted here. We do not use SQL Baseline and our System
> Stats have not been re-gathered. I did not realize that Dynamic
> Sampling can happen even with Stats in place. Thanks Randolf for
> pointing that out. That might have contributed to the plan changes.
>
> Thanks.
Date: Sat, 20 Feb 2010 01:50:54 -0800 (PST)
Message-ID: <53a06fb2-1823-47e0-bf8a-733aaaae281d_at_l19g2000yqb.googlegroups.com>
On Feb 19, 2:43 pm, amy <amykl..._at_gmail.com> wrote:
> Thanks everyone for your responses. The issue has not resurfaced after
> I posted this question. I was hoping to check out some of the
> suggestions posted here. We do not use SQL Baseline and our System
> Stats have not been re-gathered. I did not realize that Dynamic
> Sampling can happen even with Stats in place. Thanks Randolf for
> pointing that out. That might have contributed to the plan changes.
>
> Thanks.
Just to point to another possibility that Richard Foote has written about. According to your description so far I thought that it doesn't apply to your particular case but I find his post useful, so I'm linking it here:
Regards,
Randolf
Oracle related stuff blog:
http://oracle-randolf.blogspot.com/
Co-author of the "OakTable Expert Oracle Practices" book: http://www.apress.com/book/view/1430226684 http://www.amazon.com/Expert-Oracle-Practices-Database-Administration/dp/1430226684 Received on Sat Feb 20 2010 - 03:50:54 CST