Re: Oracle11g in Production??
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: dreveewee@xxxxxxxxx, jkstill@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2009 12:15:07 -0800 (PST)
The reason it's still there, is that ruling out RULE may have some COST :)
On similar note (as issues seen in production), did anyone have any bad
experiences to share when upgrading to 11g (say from 10.2.0.3)? What are the
options to consider for upgrades when we talk about 10-15+TB size?
Thanks,
Deepak
________________________________
From: Andre van Winssen <dreveewee@xxxxxxxxx>
To: jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Cc: Chandra_Pabba@xxxxxxxxxxx
Sent: Friday, February 20, 2009 12:44:08 PM
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:
