Re: 11g R2 Feedback?

For those of you on 11g-  OLTP, DSS or OLAP?  Our warehouse is 7TB and our 
datamarts hit around 10TB each, so I do have concerns about warehouse features, 
especially new DML compression, partitioning, improvements in dynamic sampling, 
parallel processing, CTAS/bulk loading, etc...
Any insight you can offer-  greatly appreciated!
Thank you for all you've provided so far as well-

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
 
"Go away before I replace you with a very small and efficient shell script..."

--- On Wed, 10/21/09, Kerry Osborne <kerry.osborne@xxxxxxxxxxx> wrote:


From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
Subject: Re: 11g R2 Feedback?
To: Mark.Bobak@xxxxxxxxxxxx
Cc: "kjped1313@xxxxxxxxx" <kjped1313@xxxxxxxxx>, "oracle Freelists" 
<oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, October 21, 2009, 5:40 PM


I concur with Mark. We have had several 11gR1 instances in production for 2 
years now. They started on 11.1.0.6 and were upgraded to 11.1.0.7 a few months 
after it was released. Most of them are RAC clusters on Dell boxes running 
Redhat. There have been very few issues and now show stoppers. We haven't made 
extensive use of new features, but all in all I'd say that this has been the 
best quality control I've seen from an initial release. The fact that the 
releases have been spaced about a year apart:


   11.1.0.6 - July 2007
   11.1.0.7 - September 2008
   11.2.0.1 - September 2009


also indicates to me that the whole development / release schedule has matured 
into a much more disciplined process.


At this point I'd be quite willing to take a chance on an initial release 
(after a couple of months of testing). Prior to 11g I would not have made that 
statement. So I'd say yeah, very positive experience with 11g in general. We 
have only rolled one R2 instance into production so far (and it was a brand new 
app) but based on the experience with R1, I would not be afraid to use it.

 





Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com









On Oct 21, 2009, at 5:58 PM, Bobak, Mark wrote:




Hi Kellyn,
 
I’ve had 11gR1 in production for over a year now, and it’s been quite stable.
 
11gR2 is still pretty new, but, we’re testing some new XML DB functionality on 
it.  So far, it seems to be stable.  This is simply a proof-of-concept at this 
point, and very low traffic, so, no production like loads on it, but, so far so 
good.  One issue, Netbackup, which my backup admin tells me is the latest 
version, can’t backup 11gR2 using RMAN.  Backup to tape w/o Netbackup MML in 
place works fine, but as soon as you try to do a backup w/ Netbackup MML, it 
crashes w/ ORA-7445.  So, I currently can’t effectively back it up.  I’m hoping 
the next release of Netbackup will resolve that issue.
 
Hope that helps,
 
-Mark

 

Other related posts: