RE: CBO irregularity

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 8 Jun 2004 11:56:01 -0400
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F7309B61515@xchgbrsm1.corp.espn.pvt>

I guess I am just lucky in this regard.

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shreeni
Sent: Tuesday, June 08, 2004 11:29 AM
To: oracle-l_at_freelists.org
Subject: RE: CBO irregularity

The last time I suggested this to mgmt ( abt QA/Prod servers ) my CTO said these words " Dont' walk in IT wonderland Mr DBA " and all & sundry in the meeting laughed till they watered in the eyes and gave me the I-told-u-so look.

Shreeni

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]

On Behalf Of Rachel Carmichael
Sent: Tuesday, June 08, 2004 10:23 AM
To: oracle-l_at_freelists.org
Subject: RE: CBO irregularity

Dennis,

I'm not sure what you're asking... if you want to know if I think a full refresh of the staging environment from a production backup is a good idea, yes I do.

Our problem was not that the data was a subset, it wasn't. The environment itself is not exactly duplicated. In production we have two database servers, in QA/stage we have one. In production, multiple applications run on the various app servers and hit the databases at the same time. In the QA load test, because the servers are smaller than production, we ran only the application we were porting. And in QA, without competition, it ran fine.

I do believe that unless QA and production are mirrors, in terms of hardware as well as software, then you do not have a true QA environment.

I *still* get the "sit down and shut up" response when I say that though.

Rachel

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 08 2004 - 10:53:10 CDT