Re:RE: Would you allow this?

From: <dgoulet_at_vicr.com>
Date: Thu, 15 Jun 2000 10:29:20 -0400
Message-Id: <10529.109407@fatcity.com>

We have had a number of tool vendors over the years who want to demo their nifty new thing-a-ma-jig for some interested end users on our production database with the notion that querying data has "no ill effects". BULL S%$#!!! The biggest problem I'm constantly fighting is not the insert or update or delete statement that runs off into never-never land, but the GOD awful query that brings the entire system to it's knees. Therefore, if they want a play area with a limited dataset on a separate server, OK give me a day or two's heads-up. Otherwise, Get the H*&^ out of here. And thankfully I've upper management's agreement on that too.

____________________Reply Separator____________________

Subject: RE: Would you allow this?
Author: Christine Turner <Christine.Turner_at_IPS-Sendero.com> Date: 6/15/00 7:09 AM

My understanding was that Cognos could only "select" from the database, nothing else. Ran into the same situation when I used to work for the State of Arizona. We set up a "temporary" database with some data that came from production. Basically just an export to import kind of thing. Oh, to settle your ideas about "bad" sql. Yes, they are notorious for sending off sql that is in dyer need of being tuned. Again, just my experience.

Take Care,
Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

-----Original Message-----

From: Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com] Sent: Wednesday, June 14, 2000 6:48 AM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: Would you allow this?

It was Cognos. I'm sure this tool is just as good at generating bad SQL as our
current reporting tool.
They don't need a big database to prove that.

Christine Turner <Christine.Turner_at_IPS-Sendero.com> on 06/13/2000 04:58:27 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Just out of curiousity.....What kind of reporting tool is it???

Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

-----Original Message-----

Sent: Tuesday, June 13, 2000 11:46 AM To: Multiple recipients of list ORACLE-L

Lisa,
Your employer sounds like a complete moron. If I was you, I would start looking for another job. One of these days (maybe now), the database is going to be hosed and YOU will get the blame for it happening.

>>> "Allin, Sean" <sallin_at_trimarine-usa.com> 06/13/00 01:32PM >>> heartfelt sympathies

-----Original Message-----

Sent: Tuesday, June 13, 2000 9:55 AM
To: Multiple recipients of list ORACLE-L

How many of you would allow a vendor to come in and do a demo on a PRODUCTION
DATABASE? I am being overridden. I am being told to allow it, it's their database and
if
they hose it (who knows what this thing is going to do?) it's their problem.
What? It's just a reporting tool, but STILL! I am concerned about it starting
runaway queries and eating up resources reserved for CUSTOMERS.

Can you feel my headache all the way from Minneapolis.... I should just take
the afternoon off.
Lisa

--

Author:
INET: Lisa_Koivu_at_gelco.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).
--

Author: Allin, Sean
INET: sallin_at_trimarine-usa.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

--

Author: William Beilstein
INET: BeilstWH_at_obg.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

--

Author: Christine Turner
INET: Christine.Turner_at_IPS-Sendero.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

--

Author:
INET: Lisa_Koivu_at_gelco.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

--

Author: Christine Turner
INET: Christine.Turner_at_IPS-Sendero.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 Received on Thu Jun 15 2000 - 09:29:20 CDT