Re: 11g R2 Feedback?
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx, kerry.osborne@xxxxxxxxxxx
- Date: Wed, 21 Oct 2009 21:24:49 -0700 (PDT)
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:
