I WISH I owned that website :)
as for the programmers.... well, it was a thought. Obviously not the
right one in this case, but it was a thought.
enjoy the rain, I hear you guys are sending it our way
Rachel
- Larry Elkins <elkinsl_at_flash.net> wrote:
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel
> > Carmichael
> >
> > Larry,
> >
> > Mine is Glenmorangie in a port finish. Write me offline for the
> address
> > :)
> >
> > Oh -- your poor programmers who have queries that don't perform in
> > production as they do in development? Have you tried export and
> > importing the statistics from production into development
> (dbms_stats)
> > and stored outlines?
>
> So you decided to change careers on us after that last gig wrapped
> up? You
> can drop the DBA part ;-)
>
> http://www.drinkgoodstuff.com/dbaliquor_ny.htm.
>
> Anyway, using DBMS_STATS for consistency could help generate the same
> plans
> in development as would be generated in prod if all other factors
> were
> constant (parameters, etc, and no they aren't, something else being
> slowly
> addressed). And using outlines to capture and exporting/importing the
> OL$
> and OL$HINTS tables after, or selected rows, from dev to prod could
> be used
> as insurance for getting the same plan when moving from dev to prod.
> But,
> they would still be executing and tuning against the test data that
> doesn't,
> in many cases, remotely resemble production in it's characteristics
> and
> distributions. So, assuming we always get the same plan in test that
> we
> would in prod because of using the same stats, the query flies in
> dev, we
> lock in the plan and move to prod, it still doesn't mean it is the
> best
> access paths for prod and the "real" data. And that's the bigger
> problem,
> the "best" access path in dev isn't necessarily the best access path
> in
> prod.
>
> And before some "sales critter" calls, yes, ways to better mimic
> production
> data, and tools versus homegrown approaches, are being considered ;-)
>
> Everyone have a good weekend. Time to go play in the rain.
>
> Larry G. Elkins
> elkinsl_at_flash.net
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Elkins
> INET: elkinsl_at_flash.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat Mar 30 2002 - 18:58:18 CST
