Hey Dan! I've seen Jerry Quarry fight, he's done better in his fights
than I have in some of mine!
did you ever do the startup tests we talked about?
Rachel
- "Daniel W. Fink" <optimaldba_at_yahoo.com> wrote:
> Rachel,
> Shall we crown you the Jerry Quarry of Oracle DBAs?
>
> -----Original Message-----
> Carmichael
> Sent: Thursday, April 25, 2002 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Some truisms I've found after losing the fight at several different
> locations:
>
> 1) If the programming staff was there before you got there, you will
> lose every fight
>
> 2) If the programming staff was hired after you got there, but has a
> prior working history with management, you will lose every fight
>
> 3) If what you ask for means going back and recoding existing
> "working"
> code, you will lose every fight
>
> 4) If you haven't convinced the development staff that it really is
> essential that you are part of the design process, you will lose
> every
> fight
>
> 5) if the code has been provided by a 3rd party vendor, you will lose
> every fight
>
> 6) "No" is a complete sentence. But it should be backed up with the
> reasons why doing whatever it is that they want you to will adversely
> impact the application. They don't care what it does to the database,
> but if it hurts the visible app, they will listen
>
> 7) DOCUMENT EVERYTHING. Every time you lose a fight, send a note to
> your home email address and to your manager explaining why you feel
> this is a bad idea. Do not send it to your office email address, it's
> too easy for those files to get lost (anyone old enough to remember
> the
> "missing 18 minutes of tape"?)
>
> --- "Orr, Steve" <sorr_at_rightnow.com> wrote:
> > > I lost the fight to have the code fixed, and so turned on
> > > cursor_sharing. Worked like a charm
> >
> > Been there, done that... but now I feel better knowing that a
> > tenacious
> > goddess of the DBA battlefields also lost this fight. :-)
> >
> > It's a tough fight when embedded SQL is scattered all over the
> place
> > and
> > development is more concerned with coding the next feature set on
> > "Internet
> > time." Apart from the tons of embedded SQL, we have a "dynamic SQL
> > generator" function in our code which creates SQL with literals
> based
> > on
> > states or values in webpage check boxes, radio buttons,
> > dropdownlists, text
> > boxes, etc. Since this is a central, oft-used part of the app I'm
> > hoping to
> > get duhvelopment to use bind variables in it but it's going to be
> an
> > uphill
> > battle. Just the normal frustration in the on-going DBA/Duhveloper
> > battle.
> > Sigh...
> >
> >
> > Steve Orr
> > Bozeman, MONTANA!
> >
> >
> > -----Original Message-----
> > Sent: Thursday, April 25, 2002 6:58 AM
> > To: Multiple recipients of list ORACLE-L
> > Importance: High
> >
> >
> > Minor correction, cursor_sharing did work in versions under 8.1.7.3
> > (I
> > used it in 8.1.6) but there was a bug relating to very specific
> > usage.
> > I never encountered it, I know you can look up the details of the
> bug
> > on Metalink.
> >
> > Having said that, I used cursor_sharing=force instead of flushing
> the
> > shared pool because it does almost entirely eliminate the "out of
> > memory" error, while flushing, if you misset the timing, doesn't.
> >
> > We had programmers who did not want to use bind variables (Java
> > prepared statements) and so, for an OLTP system where they were
> > looking
> > up registration information, we ended up with each SQL statement,
> > differing only by the constant value being looked up, in the shared
> > pool.
> >
> > I lost the fight to have the code fixed, and so turned on
> > cursor_sharing. Worked like a charm
> >
> > Rachel
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Orr, Steve
> > INET: sorr_at_rightnow.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Daniel W. Fink
> INET: optimaldba_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).
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.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 Thu Apr 25 2002 - 21:13:21 CDT