Re: Oracle11g in Production??
Date: Fri, 20 Feb 2009 19:44:08 +0100
we are running production databases 220.127.116.11 on AIX 5.3 and soon also on AIX 6.1.
the production database was rebuilt from an 8.0.5 database
11g offers lots of easy handles for finding performance improvements but on the other hand my client also noticed that certain queries referencing views that had the RULE hint ran three times faster than without the RULE. stats were all up-to-date ansd not locked.
when can we RULE out the old optimizer?
2009/2/20 Jared Still <jkstill_at_gmail.com>
> On Fri, Feb 20, 2009 at 7:29 AM, Chandra Pabba <Chandra_Pabba_at_verizon.net
> > wrote:
>> I just wanted to check to see if anyone out there have implemented
>> Oracle11g in production yet and what the feedback is. I did a search but
>> couldn't find this information.
>> We are running 3 18.104.22.168 databases in a production environment.
> No issues with any of them.
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
-- regards, Andre -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 20 2009 - 12:44:08 CST