Re: 1 minutes: best downtime story
From: Adric Norris <landstander668_at_gmail.com>
Date: Fri, 15 Mar 2013 15:08:08 -0500
Message-ID: <CAJueESpgEM0J5gT4dg2znUueR4RjZogwMLMA45xeRkOX=qXrqw_at_mail.gmail.com>
On Fri, Mar 15, 2013 at 2:41 PM, Uzzell, Stephan <SUzzell_at_micros.com> wrote:
> Or if dev/test don't quite match prod? I pulled this from Toad one day,
> after a new report was deployed to one of our prod environments:
>
> SELECT STATEMENT ALL_ROWS Cost: 1.84467440737096E19
>
Date: Fri, 15 Mar 2013 15:08:08 -0500
Message-ID: <CAJueESpgEM0J5gT4dg2znUueR4RjZogwMLMA45xeRkOX=qXrqw_at_mail.gmail.com>
On Fri, Mar 15, 2013 at 2:41 PM, Uzzell, Stephan <SUzzell_at_micros.com> wrote:
> Or if dev/test don't quite match prod? I pulled this from Toad one day,
> after a new report was deployed to one of our prod environments:
>
> SELECT STATEMENT ALL_ROWS Cost: 1.84467440737096E19
>
That one's almost impressive in its sheer awfulness. I recently helped tune a statement with a cost of 6 trillion in one of our data warehouses, and thought I'd seen it all at that point...
Apparently your developer was even more talented than mine! ;)
-- "I'm too sexy for my code." -Awk Sed Fred -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2013 - 21:08:08 CET