Re: 11g R2 Feedback?

From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Wed, 21 Oct 2009 21:24:49 -0700 (PDT)
Message-ID: <963179.39797.qm_at_web32006.mail.mud.yahoo.com>

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_at_enkitec.com> wrote:

From: Kerry Osborne <kerry.osborne_at_enkitec.com> Subject: Re: 11g R2 Feedback?
To: Mark.Bobak_at_proquest.com
Cc: "kjped1313_at_yahoo.com" <kjped1313_at_yahoo.com>, "oracle Freelists" <oracle-l_at_freelists.org> 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

 

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 21 2009 - 23:24:49 CDT