Re: very impressed by 11g
From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: Thu, 26 Apr 2012 00:14:15 -0700 (PDT)
Message-ID: <1869807.1112.1335424455801.JavaMail.geo-discussion-forums_at_ynjj38>
Op woensdag 25 april 2012 20:55:44 UTC+2 schreef Gerard H. Pille het volgende:
> John Hurley wrote:
> > On Apr 24, 3:50 pm, "Gerard H. Pille"<g..._at_skynet.be> wrote:
> >> Months ago we upgraded our main database to 11g, and after tuning a number of selects, we were
> >> running happily along. A couple of weeks ago, we noticed we'd forgotten to change the
> >> compatible parameter to 11.2 or something, so, yesterday we set that straight.
> >
> > You did not test out the impact of changing the compatible parameter
> > for your "main database" prior to the production implementation?
> >
> > Can you clone your database and setup an adequate test environment and
> > figure out what has changed?
>
>
> Sorry about that, John, but I was not involved until I noticed smoke coming out of that machine.
> There a number of other databases and application servers that keep me 100% occupied. But I
> run some automated checks on all the systems and they warned me.
Date: Thu, 26 Apr 2012 00:14:15 -0700 (PDT)
Message-ID: <1869807.1112.1335424455801.JavaMail.geo-discussion-forums_at_ynjj38>
Op woensdag 25 april 2012 20:55:44 UTC+2 schreef Gerard H. Pille het volgende:
> John Hurley wrote:
> > On Apr 24, 3:50 pm, "Gerard H. Pille"<g..._at_skynet.be> wrote:
> >> Months ago we upgraded our main database to 11g, and after tuning a number of selects, we were
> >> running happily along. A couple of weeks ago, we noticed we'd forgotten to change the
> >> compatible parameter to 11.2 or something, so, yesterday we set that straight.
> >
> > You did not test out the impact of changing the compatible parameter
> > for your "main database" prior to the production implementation?
> >
> > Can you clone your database and setup an adequate test environment and
> > figure out what has changed?
>
>
> Sorry about that, John, but I was not involved until I noticed smoke coming out of that machine.
> There a number of other databases and application servers that keep me 100% occupied. But I
> run some automated checks on all the systems and they warned me.
I hear now that that parameter change had been done in development and test databases, but probably we did not put enough load on those systems. But, as Mladen pointed out, we should have known, given the PSU documentation. Received on Thu Apr 26 2012 - 02:14:15 CDT