RE: Oracle11g in Production??

  • From: "Chandra Pabba" <Chandra_Pabba@xxxxxxxxxxx>
  • To: <dreveewee@xxxxxxxxx>, <jkstill@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 Feb 2009 16:10:43 -0600

Dan, Jared,  Andre, Bill, Mark, Toon, 

 

Thanks for the information and feedback.  Appreciate your responses. 

 

Thanks again!
Chandra

 

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Andre van Winssen
Sent: Friday, February 20, 2009 12:44 PM
To: jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Cc: Chandra_Pabba@xxxxxxxxxxx
Subject: Re: Oracle11g in Production??

 

 

we are running production databases 11.1.0.7 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?

 

Andre

2009/2/20 Jared Still <jkstill@xxxxxxxxx>

On Fri, Feb 20, 2009 at 7:29 AM, Chandra Pabba <Chandra_Pabba@xxxxxxxxxxx>
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 11.1.0.7 databases in a production environment.
No issues with any of them.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

 




-- 
regards,
Andre

Other related posts: