Is 11g ready for Production....?

mc...@hotmail.com

unread,

Jul 10, 2008, 8:34:28 PM7/10/08

to

We are considering upgrading our Enterprise Edition database from
10gR2 to 11g.

My instinct tells me that its a bad idea to upgrade to the first
release of a major version. I've been burnt in the past by upgrading
to 9iR1 and 10gR1 (both of which I thought were useless).

11g has been out for a while now, is 11gR2 due to be released soon..?

Is anyone running 11gR1 in production. Good experience... bad
experience..?

Matt

Mladen Gogala

unread,

Jul 11, 2008, 4:37:40 AM7/11/08

to

On Thu, 10 Jul 2008 17:34:28 -0700, mccmx wrote:

> Is anyone running 11gR1 in production. Good experience... bad
> experience..?

Depends on the applications running. I converted one reporting database to
11g because of the large amount of repetitive queries in the web
application and it did deliver the performance increase that I expected
from it. On the other hand, I tried compressing table for all operations
and got a bunch of ORA-0600. I don't yet have any OLTP databases on
Oracle11. I guess that the answer is: "it depends".

--
Mladen Gogala
http://mgogala.freehostia.com

mc...@hotmail.com

unread,

Jul 11, 2008, 9:48:58 AM7/11/08

to

> Depends on the applications running. I converted one reporting database to
> 11g because of the large amount of repetitive queries in the web
> application and it did deliver the performance increase that I expected
> from it.

What feature gave you the performance benefit - was it the SQL result
cache..?

Matt

Mladen Gogala

unread,

Jul 11, 2008, 1:08:30 PM7/11/08

to

On Fri, 11 Jul 2008 06:48:58 -0700, mccmx wrote:

> What feature gave you the performance benefit - was it the SQL result
> cache..?

Yes.

--
http://mgogala.freehostia.com

DA Morgan

unread,

Jul 11, 2008, 8:20:21 PM7/11/08

to

Definitely. I have several production applications with consulting
customers running in 11g and not one of them has had any reason to
regret the decision.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mladen Gogala

unread,

Jul 13, 2008, 6:44:10 AM7/13/08

to

On Fri, 11 Jul 2008 17:20:21 -0700, DA Morgan wrote:

> Definitely. I have several production applications with consulting
> customers running in 11g and not one of them has had any reason to
> regret the decision.

Do you know when will the CPU patch for July be out and whether it will
contain any significant changes? I am planning my vacation and my boss
wants to know whether he will have to apply it right away?

--
http://mgogala.freehostia.com

DA Morgan

unread,

Jul 14, 2008, 2:04:33 AM7/14/08

to

Even if I knew, which I don't, I couldn't say.

So why ask? <g>

Dennis Yurichev

unread,

Jul 14, 2008, 8:41:22 AM7/14/08

to

http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpujul2008.html

==
Oracle Database Executive Summary

This Critical Patch Update contains 11 new security fixes for the
Oracle Database. None of these vulnerabilities may be remotely
exploited without authentication, i.e., may be exploited over a
network without the need for a username and password. None of these
fixes are applicable to Oracle Database client-only installations,
i.e., installations that do not have the Oracle Database installed.
==